ExcelComponent
Configures the settings for exporting the TreeList to Excel. See example.
<kendo-treelist [data]="data" [height]="500">
<kendo-treelist-excel fileName="Employees.xlsx"></kendo-treelist-excel>
</kendo-treelist>
Selector
kendo-treelist-excel
Inputs
Name | Type | Default | Description |
---|---|---|---|
allPages |
|
|
Specifies if export should include all pages. |
collapsible |
|
Specifies if item levels in the Excel file are collapsible. Applies only if the TreeList has footers. | |
creator? |
|
Sets the author of the workbook. | |
date? |
|
Sets the date the workbook was created. Defaults to | |
expandAll |
|
|
Specifies if the export should expand all items or use the current TreeList state. |
fetchData |
|
The function used to get the exported data options. By default, uses the current TreeList data. To export data different from the current TreeList data, provide a custom function. | |
fileName |
|
|
Specifies the file name of the exported Excel file. |
filterable |
|
Enables or disables column filtering in the Excel file. This is different from the TreeList filtering feature. | |
forceProxy |
|
If set to | |
paddingCellOptions |
|
The options for the cells inserted before the data to indicate the hierarchy. | |
proxyURL |
|
The URL of the server-side proxy that streams the file to the user. Use a proxy if the browser cannot save 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 The proxy receives a POST request with specific parameters in the request body. See example.
The proxy returns the decoded file with the For details on server-side proxy usage and implementation, see the File Saver documentation. |