WorkbookBase.FileFormat Property
Gets the file format and type of the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property FileFormat As XlFileFormat
Get
public XlFileFormat FileFormat { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlFileFormat
One of the XlFileFormat values.
Examples
The following code example checks the value of the FileFormat property to determine whether the workbook is a normal workbook. If the workbook is a normal workbook, then the example calls the SaveAs method to resave the workbook as an XML spreadsheet with the name XMLCopy.xls in the path specified by the Path property.
This example is for a document-level customization.
Private Sub WorkbookSaveAs()
If Me.FileFormat = Excel.XlFileFormat.xlWorkbookNormal Then
Me.SaveAs(Me.Path & "\XMLCopy.xml", _
Excel.XlFileFormat.xlXMLSpreadsheet, _
AccessMode:=Excel.XlSaveAsAccessMode.xlNoChange)
End If
End Sub
private void WorkbookSaveAs()
{
if (this.FileFormat == Excel.XlFileFormat.xlWorkbookNormal)
{
this.SaveAs(this.Path + @"\XMLCopy.xml",
Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing,
false, false, Excel.XlSaveAsAccessMode.xlNoChange,
missing, missing, missing, missing, missing);
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.