New to Kendo UI for jQuery? Download free 30-day trial

Export to Excel

Loading Demo...
  • EXAMPLE
  • VIEW SOURCE
  • excel-export.html
  • Sample service

Also available for:

API REFERENCE

Description

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.

The demo also demonstrates how a Grid column can be excluded from exporting via the Exportable setting.

Support & Learning Resources