Grid / Export to Excel
When using grid, it is often useful and important to export your data to MS Excel in order to make it accessible offline, share it with your colleagues, etc.
The Kendo UI grid provides client Excel export functionality (server-agnostic) which can be directly utilized to serve the purpose to share data in the aforementioned ways. To enable it, include the corresponding command to the grid toolbar and configure the export settings accordingly. Alternatively, you can trigger Excel export by invoking the saveAsExcel method from the client API of the grid.
Additionally, you have the option to customize the rows/columns and cells of the exported file by intercepting the excelExport event. More information on this topic can be found in the following documentation article.
- Sample service
- Widget configuration