TreeListXlExportOptions Properties

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

Name	Description
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 TreeListExportOptions.
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 TreeList 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, date-time, and currency data formatting settings. Inherited from TreeListExportOptions.
DocumentOptions	Specifies detailed information applied to the resulting document.
EncryptionOptions	Specifies encryption options applied to the output document.
ExportColumnHeaders	Specifies whether the TreeList exports column headers.
ExportDisplayText	Indicates whether the TreeList exports cell values in the same format they are presented in the compoment. Inherited from TreeListExportOptions.
ExportSelectedRowsOnly	Specifies whether the TreeList exports selected rows only. Inherited from TreeListExportOptions.
ExportTotalSummaries	Specifies whether the TreeList exports total summaries.
RowExpandMode	Specifies how the TreeList export nodes that contain child nodes.
RowExporting	Fires before a row is exported and allows you to cancel the action. Inherited from TreeListExportOptions.
SheetName	Specifies a name of the sheet in the exported document.
ShowHeaderBands	Specifies whether the TreeList exports header bands.
SuppressEmptyStrings	Specifies whether the TreeList export empty strings as blank cells in Excel formats.
SuppressMaxColumnCountError	Specifies whether to suppress the exception thrown when exporting more than 256 columns to an XLS file or more than 16,384 columns to 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.