GridXlExportOptions Properties

Contains options that define how a document is exported to XLS and XLSX.

Name	Description
CalcTotalSummaryOnCompositeRange	Specifies whether a total summary exported as the SUBTOTAL function that excludes references to cells with group summary values.
CountBlankCellsInSummary	Specifies whether the Count summary function takes blank cells into account when exporting data in Excel formats.
CustomizeCell	Allows you to customize a cell in the exported file. Inherited from GridExportOptions.
CustomizeColumn	Allows you to customize an individual column in the exported document.
CustomizeSheet	Allows you to customize sheet settings in the exported document.
CustomizeSheetFooter	Allows you to add rows below grid content in the output document.
CustomizeSheetHeader	Allows you to add rows above grid content in the output document.
DocumentCulture	Specifies the exported document’s culture that defines numeric and date-time data formatting settings. Inherited from GridExportOptions.
DocumentOptions	Specifies detailed information applied to the resulting document.
EncryptionOptions	Contains encryption options applied to the output document.
ExportColumnHeaders	Specifies whether the grid exports column headers.
ExportDisplayText	Indicates whether the Grid exports cell values in the same format they are presented in the grid. Inherited from GridExportOptions.
ExportGroupSummaries	Specifies whether the grid exports group footer summaries.
ExportSelectedRowsOnly	Specifies if the grid exports only selected rows. Inherited from GridExportOptions.
ExportTotalSummaries	Specifies whether the grid exports total summaries.
ExportUnboundExpressionAsFunction	Specifies whether the grid exports an unbound column expression as a function or as a result value.
GroupExportMode	Specifies how the grid exports group rows.
RowExporting	Fires before a row is exported and allows you to cancel the action. Inherited from GridExportOptions.
SheetName	Specifies the name of the sheet in the exported document.
ShowHeaderBands	Specifies whether the grid exports header bands.
SuppressEmptyStrings	Specifies whether the grid export empty strings as blank cells in Excel formats.
SuppressMaxColumnCountError	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.
SuppressMaxRowCountError	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.