Back to Devexpress

GridXlExportOptions Members

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

latest7.3 KB
Original Source

GridXlExportOptions Members

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

Constructors

NameDescription
GridXlExportOptions()Initializes a new instance of the GridXlExportOptions class.

Properties

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.

Methods

NameDescription
Equals(Object, Object) staticDetermines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode()Serves as the default hash function. Inherited from Object.
GetType()Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protectedCreates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
ToString()Returns a string that represents the current object. Inherited from Object.

See Also

GridXlExportOptions Class

DevExpress.Blazor Namespace