ExcelComponent

Configures the settings for the export of TreeList in Excel (see example).

Selector

kendo-treelist-excel

Inputs

Name	Type	Default	Description
allPages	boolean	true	Specifies if export should include all pages
collapsible	boolean		Specifies if the item levels in the Excel file are collapsible. Applicable only if the treelist has footers.
creator?	string		The author of the workbook.
date?	Date		The date on which the workbook was created. Defaults to new Date().
expandAll	boolean	true	Specifies if the export should expand all items or should use the current TreeList state.
fetchData	(component: TreeListComponent) => ExcelExportData		The function that is used to get the exported data options. By default, uses the current data of the TreeList. To export data that is different from the current TreeList data, provide a custom function.
fileName	string	"Export.xlsx"	Specifies the file name of the exported Excel file.
filterable	boolean		Enables or disables column filtering in the Excel file. This behavior is different from the filtering feature of the TreeList.
forceProxy	boolean		If set to true, the content is forwarded to proxyURL even if the browser supports the saving of files locally.
paddingCellOptions	CellOptions		The options of the cells that are inserted before the data to indicate the hierarchy.
proxyURL	string		The URL of the server-side proxy which streams the file to the end user. Using a proxy is required if the browser is not capable of saving files locally. Optionally, set up a proxy to reduce memory usage. This avoids copying the file contents into memory, but transmits it over the network instead. For this use case, set forceProxy to true to skip client-side saving even in browsers that support it. In the request body, the proxy receives a POST request with the specific parameters. See example. The proxy returns the decoded file with the "Content-Disposition" header set to attachment; filename="<fileName.xslx>". For details on the server-side proxy usage and implementation, see the File Saver documentation.