New to Telerik UI for ASP.NET MVC? 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

Also available for:

API REFERENCE

Units in stock

	Product name	Unit price	Units On Order	Units in stock

kendo.syncReady(function(){jQuery("#grid").kendoGrid({"columns":[{"title":"Product name","headerAttributes":{"data-field":"ProductName","data-title":"Product\u0026#32;name","data-aggregates":"count"},"width":"300px","footerTemplate":"Total Count: #=count#","groupFooterTemplate":"Count: #=count#","field":"ProductName","encoded":true,"aggregates":["count"]},{"title":"Unit price","headerAttributes":{"data-field":"UnitPrice","data-title":"Unit\u0026#32;price","data-aggregates":"sum"},"width":"300px","field":"UnitPrice","format":"{0:C}","encoded":true,"aggregates":["sum"]},{"title":"Units On Order","headerAttributes":{"data-field":"UnitsOnOrder","data-title":"Units\u0026#32;On\u0026#32;Order","data-aggregates":"average"},"width":"300px","footerTemplate":"Average: #=average#","groupFooterTemplate":"Average: #=average#","exportable":false,"field":"UnitsOnOrder","encoded":true,"aggregates":["average"]},{"title":"Units in stock","headerAttributes":{"data-field":"UnitsInStock","data-title":"Units\u0026#32;in\u0026#32;stock","data-aggregates":"min,max,count"},"width":"300px","footerTemplate":"Min: #= min # Max: #= max #","field":"UnitsInStock","encoded":true,"aggregates":["min","max","count"],"groupHeaderTemplate":"Units In Stock: #= value # (Count: #= count#)"}],"groupable":{"enabled":true},"pageable":{"buttonCount":10},"sortable":true,"excel":{"proxyURL":"/aspnet-mvc/grid/excel_export_save","fileName":"Kendo UI Grid Export.xlsx","filterable":true},"columnMenu":true,"resizable":true,"reorderable":true,"scrollable":false,"toolbar":{"command":[{"name":null,"attr":" type=\"button\"","buttonType":"ImageAndText","text":"Export to 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-mvc/grid/excel_export_read"},"prefix":""},"pageSize":7,"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 MVC Grid extension.
You have to include the Excel toolbar command .ToolBar(tools => tools.Excel()) as well as to 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. You can find more information in the following help article.

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