Skip to main content

GridXlExportOptions Members

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

Constructors

Name Description
GridXlExportOptions() Initializes a new instance of the GridXlExportOptions class.

Properties

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

Methods

Name Description
Equals(Object, Object) static Determines 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() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines 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