Skip to main content

XlsxExportOptions Members

Contains options which define how grid data is exported to XLSX format.

Constructors

Name Description
XlsxExportOptions() Initializes a new instance of the XlsxExportOptions class with default settings.

Fields

Name Description
AllowGroupingProperty static Identifies the DataAwareExportOptionsBase.AllowGrouping bindable property. Inherited from DataAwareExportOptionsBase.
AllowLookupValuesProperty static Identifies the DataAwareExportOptionsBase.AllowLookupValues bindable property. Inherited from DataAwareExportOptionsBase.
AllowSortingAndFilteringProperty static Identifies the DataAwareExportOptionsBase.AllowSortingAndFiltering bindable property. Inherited from DataAwareExportOptionsBase.
ExportHyperlinksProperty static Identifies the XlsExportOptionsBase.ExportHyperlinks bindable property. Inherited from XlsExportOptionsBase.
GroupStateProperty static Identifies the DataAwareExportOptionsBase.GroupState bindable property. Inherited from DataAwareExportOptionsBase.
RawDataModeProperty static Identifies the XlsExportOptionsBase.RawDataMode bindable property. Inherited from XlsExportOptionsBase.
SheetNameProperty static Identifies the XlsExportOptionsBase.SheetName bindable property. Inherited from XlsExportOptionsBase.
ShowColumnHeadersProperty static Identifies the DataAwareExportOptionsBase.ShowColumnHeaders bindable property. Inherited from DataAwareExportOptionsBase.
ShowGridLinesProperty static Identifies the XlsExportOptionsBase.ShowGridLines bindable property. Inherited from XlsExportOptionsBase.
ShowGroupSummariesProperty static Identifies the DataAwareExportOptionsBase.ShowGroupSummaries bindable property. Inherited from DataAwareExportOptionsBase.
ShowPageTitleProperty static Identifies the DataAwareExportOptionsBase.ShowPageTitleProperty bindable property. Inherited from DataAwareExportOptionsBase.
ShowTotalSummariesProperty static Identifies the DataAwareExportOptionsBase.ShowTotalSummaries bindable property. Inherited from DataAwareExportOptionsBase.

Properties

Name Description
AllowGrouping Gets or sets whether data groups are exported from the source grid to the output document. Inherited from DataAwareExportOptionsBase.
AllowLookupValues Gets or sets whether lookup values of picker columns are exported. Inherited from DataAwareExportOptionsBase.
AllowSortingAndFiltering Gets or sets whether the sorting and filtering functionality is enabled for columns in the exported document. Inherited from DataAwareExportOptionsBase.
ExportHyperlinks Gets or sets a value indicating whether hyperlinks should be exported to XLS or XLSX. Inherited from XlsExportOptionsBase.
GroupState Gets or sets whether data groups are collapsed or expanded in the exported document. Inherited from DataAwareExportOptionsBase.
RawDataMode Specifies whether a grid’s actual data should be exported to XLS or XLSX (excluding all non-relevant elements, such as images, graphics, font and appearance settings). Inherited from XlsExportOptionsBase.
SheetName Gets or sets the name of the sheet in the created XLS or XLSX file to which a document is exported. Inherited from XlsExportOptionsBase.
ShowColumnHeaders Gets or sets whether column headers are visible in the exported document. Inherited from DataAwareExportOptionsBase.
ShowGridLines Gets or sets a value indicating whether grid lines should be visible in the resulting XLS or XLSX file. Inherited from XlsExportOptionsBase.
ShowGroupSummaries Gets or sets whether group summaries are enabled in the exported document. Inherited from DataAwareExportOptionsBase.
ShowTotalSummaries Gets or sets whether total summaries are enabled in the exported document. Inherited from DataAwareExportOptionsBase.

Methods

Name Description
Assign(ExportOptionsBase) Copies all settings from the options object passed as a parameter. Inherited from DataAwareExportOptionsBase.

Events

Name Description
CustomizeCell When exporting data from the grid to XLS or XLSX format, this event allows you to customize a cell in the output document. Inherited from DataAwareExportOptionsBase.
CustomizeDataArea When exporting to XLS or XLSX format, this event allows you to customize data in the output document. Inherited from DataAwareExportOptionsBase.
CustomizeFooter When exporting to XLS or XLSX format, this event allows you to add a footer to the output document. Inherited from DataAwareExportOptionsBase.
CustomizeHeader When exporting to XLS or XLSX format, this event allows you to add a header to the output document. Inherited from DataAwareExportOptionsBase.
CustomizeSheet When exporting to XLS or XLSX format, this event allows you to customize the output document’s settings. Inherited from DataAwareExportOptionsBase.
ExportProgress Fires repeatedly while the data is being exported. Inherited from DataAwareExportOptionsBase.
See Also