Worksheet.ExportAsFixedFormat Method (XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

 

Exports to a file of the specified format.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

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.XlFixedFormatType

One of the Microsoft.Office.Interop.Excel.XlFixedFormatType values that specifies whether to save the workbook in PDF or XPS format.

Filename
Type: System.Object

The 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.Object

One of the Microsoft.Office.Interop.Excel.XlFixedFormatQuality values that specifies the quality of the exported file.

IncludeDocProperties
Type: System.Object

true to include document properties in the exported file; otherwise, false.

IgnorePrintAreas
Type: System.Object

true to ignore any print areas set when exporting; otherwise, false.

From
Type: System.Object

The number of the page at which to start exporting. If this argument is omitted, exporting starts at the first page.

To
Type: System.Object

The number of the last page to export. If this argument is omitted, exporting ends with the last page.

OpenAfterPublish
Type: System.Object

true to display the file in the viewer immediately; otherwise, false.

FixedFormatExtClassPtr
Type: System.Object

A 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.

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.

Return to top
Show: