New to Telerik UI for ASP.NET Core? Download free 30-day trial

Export to Excel

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Theme Builder
Change Theme
Default
SASS

LESS
- Default
- Bootstrap
- Material
- Launch Theme Builder
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

            
                        excel_export.cshtml
                    
                        Excel_ExportController.cs
                    
                        ProductService.cs
                    
                        ProductViewModel.cs

Also available for:

API REFERENCE

kendo.syncReady(function(){jQuery("#grid").kendoGrid({"columnMenu":true,"excel":{"fileName":"Kendo UI Grid Export.xlsx","filterable":true,"proxyURL":"/aspnet-core/grid/excel_export_save"},"groupable":{"enabled":true},"sortable":true,"columns":[{"title":"Product name","width":"300px","footerTemplate":"Total Count: #=count#","groupFooterTemplate":"Count: #=count#","field":"ProductName","filterable":{"messages":{"selectedItemsFormat":"{0} selected items"},"checkAll":false},"encoded":true,"aggregates":["count"]},{"title":"Unit price","width":"300px","field":"UnitPrice","format":"{0:C}","filterable":{"messages":{"selectedItemsFormat":"{0} selected items"},"checkAll":false},"encoded":true,"aggregates":["sum"]},{"title":"Units On Order","width":"300px","footerTemplate":"Average: #=average#","groupFooterTemplate":"Average: #=average#","exportable":false,"field":"UnitsOnOrder","filterable":{"messages":{"selectedItemsFormat":"{0} selected items"},"checkAll":false},"encoded":true,"aggregates":["average"]},{"title":"Units in stock","width":"300px","footerTemplate":"Min: #= min # Max: #= max #","field":"UnitsInStock","filterable":{"messages":{"selectedItemsFormat":"{0} selected items"},"checkAll":false},"encoded":true,"aggregates":["min","max","count"],"groupHeaderTemplate":"Units In Stock: #= value # (Count: #= count#)"}],"pageable":{"buttonCount":10},"resizable":true,"reorderable":true,"scrollable":{"height":"400px"},"toolbar":[{"text":"Export to Excel","name":"excel"}],"dataSource":{"type":(function(){if(kendo.data.transports['aspnetmvc-ajax']){return 'aspnetmvc-ajax';} else{throw new Error('The kendo.aspnetmvc.min.js script is not included.');}})(),"transport":{"read":{"url":"/aspnet-core/grid/excel_export_read"},"prefix":""},"pageSize":10,"page":1,"groupPaging":false,"total":0,"serverPaging":true,"serverSorting":true,"serverFiltering":true,"serverGrouping":true,"serverAggregates":true,"group":[{"field":"UnitsInStock","dir":"asc","aggregates":[{"field":"UnitsInStock","aggregate":"min"},{"field":"UnitsInStock","aggregate":"max"},{"field":"UnitsInStock","aggregate":"count"},{"field":"UnitsOnOrder","aggregate":"average"},{"field":"ProductName","aggregate":"count"},{"field":"UnitPrice","aggregate":"sum"}]}],"aggregate":[{"field":"UnitsInStock","aggregate":"min"},{"field":"UnitsInStock","aggregate":"max"},{"field":"UnitsInStock","aggregate":"count"},{"field":"UnitsOnOrder","aggregate":"average"},{"field":"ProductName","aggregate":"count"},{"field":"UnitPrice","aggregate":"sum"}],"filter":[],"schema":{"data":"Data","total":"Total","errors":"Errors","model":{"fields":{"ProductID":{"type":"number"},"ProductName":{"type":"string"},"UnitPrice":{"type":"number"},"UnitsInStock":{"type":"number"},"Discontinued":{"type":"boolean"},"LastSupply":{"type":"date"},"UnitsOnOrder":{"type":"number"},"Category":{"type":"object"},"CategoryID":{"type":"number","defaultValue":null},"QuantityPerUnit":{"type":"string"}}}}}});});

Description

This example shows how to enable the Export to Excel functionality of the Telerik for ASP.NET Core Grid.
You have to include the Excel toolbar command .ToolBar(tools => tools.Excel()) as well as specify the FileName export setting.

Alternatively, you could force the Excel export by invoking the saveAsExcel() method from the Client-side API of the component.

Yet another useful option is the ability to customize the grid’s rows/columns and cells of the exported file by intercepting the excelExport event.

More about the Telerik Grid for ASP.NET Core

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

Export to Excel

Description

Support & Learning Resources

Was this demo helpful?

Tell us how we can improve this demo