Worksheet.ExportAsFixedFormat Method
Exports to a file of the specified format.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Sub ExportAsFixedFormat ( _
Type As XlFixedFormatType, _
Filename As Object, _
Quality As Object, _
IncludeDocProperties As Object, _
IgnorePrintAreas As Object, _
From As Object, _
To As Object, _
OpenAfterPublish As Object, _
FixedFormatExtClassPtr As Object _
)
void ExportAsFixedFormat(
XlFixedFormatType Type,
Object Filename,
Object Quality,
Object IncludeDocProperties,
Object IgnorePrintAreas,
Object From,
Object To,
Object OpenAfterPublish,
Object FixedFormatExtClassPtr
)
Parameters
Type
Type: Microsoft.Office.Interop.Excel.XlFixedFormatTypeOne of the Microsoft.Office.Interop.Excel.XlFixedFormatType values that specifies whether to save the workbook in PDF or XPS format.
Filename
Type: System.ObjectThe full path of the new PDF or XPS file. If you omit this parameter, Excel saves the file in the current folder.
Quality
Type: System.ObjectOne of the Microsoft.Office.Interop.Excel.XlFixedFormatQuality values that specifies the quality of the exported file.
IncludeDocProperties
Type: System.Objecttrue to include document properties in the exported file; otherwise, false.
IgnorePrintAreas
Type: System.Objecttrue to ignore any print areas set when exporting; otherwise, false.
From
Type: System.ObjectThe number of the page at which to start exporting. If this argument is omitted, exporting starts at the first page.
To
Type: System.ObjectThe number of the last page to export. If this argument is omitted, exporting ends with the last page.
OpenAfterPublish
Type: System.Objecttrue to display the file in the viewer immediately; otherwise, false.
FixedFormatExtClassPtr
Type: System.ObjectA pointer to an implementation of the IMsoDocExporter interface that enables the workbook to be saved in a different fixed format. For more information, see Extending the Office (2007) Fixed-Format Export Feature.
Remarks
This method also supports initializing an add-in to export a file to a fixed-format file. For example, Excel will perform file format conversion if the converters are present. The conversion is usually initiated by the user.
.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.