Back to Devexpress

GridXlExportOptions Properties

blazor-devexpress-dot-blazor-dot-gridxlexportoptions-dot-underscore-properties.md

latest5.1 KB
Original Source

GridXlExportOptions Properties

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

NameDescription
CalcTotalSummaryOnCompositeRangeSpecifies whether a total summary exported as the SUBTOTAL function that excludes references to cells with group summary values.
CountBlankCellsInSummarySpecifies whether the Count summary function takes blank cells into account when exporting data in Excel formats.
CustomizeCellAllows you to customize a cell in the exported file. Inherited from GridExportOptions.
CustomizeColumnAllows you to customize an individual column in the exported document.
CustomizeSheetAllows you to customize sheet settings in the exported document.
CustomizeSheetFooterAllows you to add rows below grid content in the output document.
CustomizeSheetHeaderAllows you to add rows above grid content in the output document.
DocumentCultureSpecifies the exported document’s culture that defines numeric and date-time data formatting settings. Inherited from GridExportOptions.
DocumentOptionsSpecifies detailed information applied to the resulting document.
EncryptionOptionsContains encryption options applied to the output document.
ExportColumnHeadersSpecifies whether the grid exports column headers.
ExportDisplayTextIndicates whether the Grid exports cell values in the same format they are presented in the grid. Inherited from GridExportOptions.
ExportGroupSummariesSpecifies whether the grid exports group footer summaries.
ExportSelectedRowsOnlySpecifies whether the Grid exports only selected rows. Inherited from GridExportOptions.
ExportTotalSummariesSpecifies whether the grid exports total summaries.
ExportUnboundExpressionAsFunctionSpecifies whether the grid exports an unbound column expression as a function or as a result value.
GroupExportModeSpecifies how the grid exports group rows.
RowExportingFires before a row is exported and allows you to cancel the action. Inherited from GridExportOptions.
SelectedRowsExportModeIn ExportSelectedRowsOnly mode, specifies whether to export parent group rows.
SheetNameSpecifies the name of the sheet in the exported document.
ShowHeaderBandsSpecifies whether the grid exports header bands.
SuppressEmptyStringsSpecifies whether the grid export empty strings as blank cells in Excel formats.
SuppressMaxColumnCountErrorSpecifies 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.
SuppressMaxRowCountErrorSpecifies 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

GridXlExportOptions Class

GridXlExportOptions Members

DevExpress.Blazor Namespace