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
Themes & Swatches

SASS

LESS

Launch Theme Builder
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Purple

Turquoise
Bootstrap Theme

Main

Main Dark

Nordic

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Main Dark

Opal

Silver
- 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:

CLIENT-SIDE API SERVER-SIDE API

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#","exportable":true,"field":"ProductName","encoded":true,"aggregates":["count"]},{"title":"Unit price","headerAttributes":{"data-field":"UnitPrice","data-title":"Unit\u0026#32;price","data-aggregates":"sum"},"width":"300px","exportable":true,"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 #","exportable":true,"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":{"columns":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

Themes & Swatches

Description

Support & Learning Resources