ExcelComponent
The component is required when exporting the data to an Excel file. The component provides different options to further configure the Excel export settings of the Grid (see example).
Definition
Package:@progress/kendo-angular-grid
Selector:kendo-grid-excel
Syntax:
<kendo-grid>
<kendo-grid-excel fileName="Export.xlsx"></kendo-grid-excel>
</kendo-grid>Inputs
collapsible
boolean
Specifies if groups in the Excel file are collapsible.
creator?
string
Sets the author of the workbook.
date?
Date
Sets the creation date of the workbook.
Provides a function to get the exported data options. By default, uses the current Grid data and group. Supply a custom function to export different data. Typically used to export all data, not just the current page see example.
fileName
string
Sets the file name for the exported Excel file.
'Export.xlsx'
filterable
boolean
Enables or disables column filtering in the Excel file. This option is different from the Grid's filtering feature.
forceProxy
boolean
Forwards the content to proxyURL even if the browser supports local file saving when set to true.
headerPaddingCellOptions
CellOptions
Sets the options for cells inserted before the header cells to align the headers and the column values when the data is grouped.
paddingCellOptions
CellOptions
Sets options for cells inserted before the data, group, and footer cells to indicate the group hierarchy if the data is grouped.
proxyURL
string
Sets the URL of the server-side proxy that streams the file to the user. Use a proxy if the browser cannot save files locally.
You can also use a proxy to reduce memory usage by transmitting the file over the network.
Set forceProxy to true to skip client-side saving.
The proxy receives a POST request with specific parameters and returns the decoded file with the "Content-Disposition" header set to attachment; filename="<fileName.xslx>".
For more details, see the File Saver documentation.