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

Copy 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

                        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

kendo.syncReady(function(){jQuery("#cellSelection").kendoGrid({"columns":[{"title":"Ship Country","headerAttributes":{"data-field":"ShipCountry","data-title":"Ship\u0026#32;Country"},"width":"300px","exportable":true,"field":"ShipCountry","encoded":true},{"title":"Freight","headerAttributes":{"data-field":"Freight","data-title":"Freight"},"width":"300px","exportable":true,"field":"Freight","encoded":true},{"title":"Order Date","headerAttributes":{"data-field":"OrderDate","data-title":"Order\u0026#32;Date"},"exportable":true,"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

Having used to the copy-paste functionality available in MS Excel, many users would want to copy grid cell content from web apps and paste in Excel, or some other place for further review, or just to duplicate it.

With the Telerik Grid HTML helper this built-in functionality is supported by setting two configuration settings: Selectable -> GridSelectionMode.Multiple and AllowCopy(true). As simple as that, your users will be able to utilize copy and paste between the browser and their apps.

Copy to Excel

Themes & Swatches

Description

Support & Learning Resources