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

ASP.NET MVC Grid Copy to Excel

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

                        copy_to_excel.cshtml
                    
                        Copy_To_ExcelController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Information

Select the cells you want to copy press Ctrl/Command + C to copy into the clipboard then go to Excel and paste

Ship Country	Freight	Order Date

(typeof KendoLicensing === 'object' && KendoLicensing.setScriptKey(''));kendo.syncReady(function(){jQuery("#cellSelection").kendoGrid({"columns":[{"title":"Ship Country","headerAttributes":{"data-field":"ShipCountry","data-title":"Ship Country"},"width":"300px","field":"ShipCountry","encoded":true},{"title":"Freight","headerAttributes":{"data-field":"Freight","data-title":"Freight"},"width":"300px","field":"Freight","encoded":true},{"title":"Order Date","headerAttributes":{"data-field":"OrderDate","data-title":"Order Date"},"field":"OrderDate","format":"{0:dd/MM/yyyy}","encoded":true}],"pageable":{"buttonCount":5},"selectable":{"mode":"Multiple, Cell"},"scrollable":false,"allowCopy":{"delimeter":null},"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/copy_to_excel_orders_read"},"prefix":""},"pageSize":10,"page":1,"groupPaging":false,"total":0,"serverPaging":true,"serverSorting":true,"serverFiltering":true,"serverGrouping":true,"serverAggregates":true,"filter":[],"schema":{"data":"Data","total":"Total","errors":"Errors","model":{"fields":{"OrderID":{"type":"number"},"CustomerID":{"type":"string"},"ContactName":{"type":"string"},"Freight":{"type":"number","defaultValue":null},"ShipAddress":{"type":"string"},"OrderDate":{"type":"date","defaultValue":null},"ShippedDate":{"type":"date","defaultValue":null},"ShipCountry":{"type":"string"},"ShipCity":{"type":"string"},"ShipName":{"type":"string"},"EmployeeID":{"type":"number","defaultValue":null}}}}},"navigatable":true});});

Description

The Telerik UI for ASP.NET MVC Data Grid delivers a built-in copy-paste functionality, similar to the one in MS Excel, which allows users to copy Data Grid cell content from web applications and paste it in Excel or another target location for further review or duplication.

This demo shows how to implement the copy-paste feature of the ASP.NET MVC Data Grid by setting the Selectable => Mode(GridSelectionMode.Multiple) and AllowCopy(true) configuration options, thus allowing the users to copy and paste content between the browser and their apps.

For more information, refer to the official Telerik UI for ASP.NET MVC Data Grid product documentation.

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 Copy to Excel

Description

Additional Apps

Support & Learning Resources

Additional Resources