Skip to main content

XlsExportOptions Members

Contains options which define how a document is exported to XLS format.

Constructors

Name Description
XlsExportOptions() Initializes a new instance of the XlsExportOptions class with the default settings.
XlsExportOptions(TextExportMode, Boolean, Boolean, Boolean, Boolean, WorkbookColorPaletteCompliance) Initializes a new instance of the XlsExportOptions class with the specified settings.
XlsExportOptions(TextExportMode, Boolean, Boolean, Boolean) Initializes a new instance of the XlsExportOptions class with the specified settings.
XlsExportOptions(TextExportMode, Boolean, Boolean) Initializes a new instance of the XlsExportOptions class with the specified text export mode, grid lines and hyperlinks settings.
XlsExportOptions(TextExportMode, Boolean) Initializes a new instance of the XlsExportOptions class with the specified text export mode and grid lines settings.
XlsExportOptions(TextExportMode) Initializes a new instance of the XlsExportOptions class with the specified text export mode.

Properties

Name Description
DocumentOptions Provides access to options to be embedded as the resulting XLS or XLSX file’s Document Properties. Inherited from XlExportOptionsBase.
EncryptionOptions Provides access to the XLS and XLSX file encryption options. Inherited from XlExportOptionsBase.
ExportHyperlinks Specifies whether or not hyperlinks should be exported to Excel. Inherited from XlExportOptionsBase.
ExportMode Specifies whether the document should be exported to a single or different XLS files, each page in a separate file.
FitToPrintedPageHeight Gets or sets whether the output document should be fit to the page height when printed. Inherited from XlExportOptionsBase.
FitToPrintedPageWidth Gets or sets whether the output document should be fit to the page width when printed. Inherited from XlExportOptionsBase.
IgnoreErrors Specifies the document errors to be ignored in a resulting Excel file. Inherited from XlExportOptionsBase.
PageRange Gets or sets the range of pages to be exported.
RasterizationResolution Specifies the resolution (in DPI) used to rasterize vector images on export to the corresponding document format. Inherited from PageByPageExportOptionsBase.
RasterizeImages Specifies whether or not vector images should be rasterized on export to the corresponding document format. Inherited from PageByPageExportOptionsBase.
RawDataMode Enables the mode that produces simple tabular data without graphic elements, style and appearance settings. Inherited from XlExportOptionsBase.
RightToLeftDocument Gets or sets whether the layout of the resulting XLS document should be aligned to support locales using right-to-left fonts. Inherited from XlExportOptionsBase.
SheetName Gets or sets a name of the sheet in the created XLS file to which a document is exported. Inherited from XlExportOptionsBase.
ShowGridLines Gets or sets whether worksheet gridlines are visible in the resulting XLS file. Inherited from XlExportOptionsBase.
Suppress256ColumnsWarning Gets or sets a value indicating whether to suppress the exception that raises when trying to export a document to an XLS file with more than 256 columns.
Suppress65536RowsWarning Gets or sets a value indicating whether to suppress the exception that raises when trying to export a document to an XLS file with more than 65,536 rows.
TextExportMode Gets or sets a value indicating whether the cells in the resulting XLS document should use the same formatting as the original document. Inherited from XlExportOptionsBase.
WorkbookColorPaletteCompliance Specifies the color palette compatibility mode with different workbooks versions.

Methods

Name Description
Assign(ExportOptionsBase) Copies all the settings from the XlsExportOptions object passed as a parameter.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also