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