ExcelComponent

The component is required when exporting the data to an Excel file. The componnet provides different options to further configure the Excel export settings of the Grid (see example).

html

<kendo-grid>
  <kendo-grid-excel fileName="Export.xlsx"></kendo-grid-excel>
</kendo-grid>

Selector

kendo-grid-excel

Inputs

Name	Type	Default	Description
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.
fetchData	FetchDataCallback		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	"Export.xlsx"	Sets the file name for the exported Excel file.
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.