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

ASP.NET MVC Grid Excel Export

Loading Demo...

EXAMPLE
VIEW SOURCE
Change Theme
default
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Ocean Blue A11Y

Purple

Turquoise
Bootstrap Theme

Main

Bootstrap 3

Bootstrap 3 Dark

Main Dark

Nordic

Turquoise

Turquoise Dark

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Material 2

Material 2 Dark

Nova
Classic Theme

Main

Green

Green Dark

Lavender

Lavender Dark

Main Dark

Metro

Metro Dark

Moonlight

Opal

Opal Dark

Silver

Silver Dark

Uniform
Fluent Theme

Main
Launch Theme Builder

                        excel_export.cshtml
                    
                        Excel_ExportController.cs
                    
                        ProductService.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

	Product name	Unit price	Units On Order	Units in stock

(typeof KendoLicensing === 'object' && KendoLicensing.setScriptKey(''));kendo.syncReady(function(){jQuery("#grid").kendoGrid({"columns":[{"title":"Product name","headerAttributes":{"data-field":"ProductName","data-title":"Product name","data-aggregates":"count","aria-haspopup":"menu"},"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 price","data-aggregates":"sum","aria-haspopup":"menu"},"width":"300px","field":"UnitPrice","format":"{0:C}","encoded":true,"aggregates":["sum"]},{"title":"Units On Order","headerAttributes":{"data-field":"UnitsOnOrder","data-title":"Units On Order","data-aggregates":"average","aria-haspopup":"menu"},"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 in stock","data-aggregates":"min,max,count","aria-haspopup":"menu"},"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":{"mode":"single"},"excel":{"proxyURL":"/aspnet-mvc/grid/excel_export_save","fileName":"Kendo UI Grid Export.xlsx","filterable":true},"columnMenu":{"messages":{"settings":"Edit Column Settings","buttonTitle":"{0} filter column settings"}},"resizable":{"columns":true},"reorderable":{"columns":true},"scrollable":false,"toolbar":{"items":[{"name":"excel","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

The ASP.NET MVC DataGrid enables you to export its content to Excel.

To enable the client-side Excel export functionality of the Grid, add a reference to the JSZip library, set the Excel() option, and specify the desired export settings. Also, include the Excel toolbar command by configuring ToolBar(tools => tools.Excel()) setting.

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

Yet another useful feature the Data Grid delivers is the option to customize the rows, columns, and cells of the exported file by intercepting the ExcelExport event.

This example shows how to enable the Export-to-Excel functionality of the Data Grid and also how to exclude a specified column from exporting by configuring the Exportable setting.

For more information about the Excel export capabilities, refer to the official Telerik UI for ASP.NET MVC documentation on exporting the Data Grid content to Excel. In addition, to implement server-side Excel export, refer to the server export Data Grid demo.

Additional Apps

This Grid example is part of a unique collection of hundreds of ASP.NET MVC demos, with which you can see all Telerik ASP.NET MVC components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in the ThemeBuilder.

ASP.NET MVC Grid Excel Export

Description

Additional Apps

Support & Learning Resources

Additional Resources