GridXlExportOptions Properties
Contains options that define how a document is exported to XLS and XLSX.
Name | Description |
---|---|
Calc |
Specifies whether a total summary exported as the SUBTOTAL function that excludes references to cells with group summary values.
|
Count |
Specifies whether the Count summary function takes blank cells into account when exporting data in Excel formats. |
Customize |
Allows you to customize a cell in the exported file.
Inherited from Grid |
Customize |
Allows you to customize an individual column in the exported document. |
Customize |
Allows you to customize sheet settings in the exported document. |
Customize |
Allows you to add rows below grid content in the output document. |
Customize |
Allows you to add rows above grid content in the output document. |
Document |
Specifies the exported document’s culture that defines numeric and date-time data formatting settings.
Inherited from Grid |
Document |
Specifies detailed information applied to the resulting document. |
Encryption |
Contains encryption options applied to the output document. |
Export |
Specifies whether the grid exports column headers. |
Export |
Indicates whether the Grid exports cell values in the same format they are presented in the grid.
Inherited from Grid |
Export |
Specifies whether the grid exports group footer summaries. |
Export |
Specifies if the grid exports only selected rows.
Inherited from Grid |
Export |
Specifies whether the grid exports total summaries. |
Export |
Specifies whether the grid exports an unbound column expression as a function or as a result value. |
Group |
Specifies how the grid exports group rows. |
Row |
Fires before a row is exported and allows you to cancel the action.
Inherited from Grid |
Sheet |
Specifies the name of the sheet in the exported document. |
Show |
Specifies whether the grid exports header bands. |
Suppress |
Specifies whether the grid export empty strings as blank cells in Excel formats. |
Suppress |
Specifies whether to suppress the exception thrown when exporting more than 256 columns in an XLS file or more than 16,384 columns in an XLSX file. |
Suppress |
Specifies whether to suppress the exception thrown when exporting more than 65,536 rows in an XLS file or more than 1,048,576 rows in an XLSX file. |
See Also