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

ASP.NET MVC Grid Paste from 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

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

                        paste_from_excel.cshtml
                    
                        Paste_From_ExcelController.cs
                    
                        OrderViewModel.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Information

Replace paste operation:

Copy cell(s) from Excel or another Telerik UI for ASP.NET MVC Grid, select the first Grid cell from which you want to start the replacing and press Ctrl/Command + V to paste the copied cell(s).

Insert paste operation:

Copy cell(s) from Excel or another Telerik UI for ASP.NET MVC Grid, select the Grid cell from which you want to start the inserting and press Ctrl/Command + V to insert a new row below the selected cell.

Ship Country	Freight	Order Date

kendo.syncReady(function(){jQuery("#grid").kendoGrid({"columns":[{"title":"Ship Country","headerAttributes":{"data-field":"ShipCountry","data-title":"Ship Country"},"field":"ShipCountry","encoded":true},{"title":"Freight","headerAttributes":{"data-field":"Freight","data-title":"Freight"},"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":{"info":false,"buttonCount":4},"selectable":{"mode":"Multiple, Cell"},"scrollable":false,"toolbar":[{"name":"paste","buttonType":"ImageAndText"}],"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/paste_from_excel_orders_read"},"prefix":""},"pageSize":5,"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,"contextMenu":true,"allowPaste":true});}); .configurator ul { list-style: disc; margin: 10px; padding: 0px 10px 0px 10px; }

Description

The Telerik UI for ASP.NET MVC Data Grid provides a built-in paste functionality that allows you to copy cells from MS Excel or another Grid component and paste them in the desired Grid. Based on the selected pasting operation, you can either replace the selected Grid cells with the copied cells or insert them as a new Grid row.

To enable the paste operations of the Grid:

Add the AllowPaste(true) option.
Make the Grid selectable by setting .Selectable(selectable => selectable.Mode(GridSelectionMode.Multiple).Type(GridSelectionType.Cell)).
Enable the keyboard navigation functionality through the Navigatable() method.
Include the Paste() command in the Grid's ToolBar to display a dropdown control with the available paste operations—Insert (Paste (Insert)) and Replace (Paste (Replace)) modes.

This demo shows how to implement the paste feature of the Data Grid to insert new rows or replace the selected cells with the copied cells from an Excel document or other Telerik UI for ASP.NET MVC Grids.

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 Paste from Excel

Description

Additional Apps

Support & Learning Resources

Additional Resources