Paste Data (multiple cells/rows) from Excel to Kendo UI Grid

[Darshan]

Hello,

I was wondering if the newer releases of Kendo UI (or RadGrid) support pasting data from Excel to the grid?

I found some older code in these forums (from 2011) that "hand implements" the paste, but I was wondering if there are any native capabilities that have been added to support pasting data to a Kendo grid (as opposed to from a kendo grid to excel). I looked through the new demos, and didn't see anything along those lines. Just wondering if this is a feature or if it's on the roadmap, as it's a highly desirable feature for an editable grid.

[Atanas Georgiev]

Hello Darshan,

At this point paste from excel capability is not supported out-of-the-box. You can vote for the following UserVoice idea, which we will consider for future releases. 

The closest suggestions we can offer at this point are:

http://docs.telerik.com/kendo-ui/web/grid/how-to/copy-from-excel-to-grid - for KendoGrid
http://www.telerik.com/forums/copy-from-excel-sheet-and-paste-it-in-radgrid - for RadGrid

Regards,
Atanas Georgiev
Telerik

 

 

[Darshan]

Thanks Atanas. I saw some posts about a future direction with a Spreadsheet component, I look forward to testing / using that when it comes out - my guess is that will be closer to what I need. I appreciate the pointers above, I will probable implement something with JavaScript as in the above examples while I wait for a more 'native' solution.

[Atanas Georgiev]

Hello Darshan,

The beta version of Spreadsheet Solution for Web is expected in October. I believe that your use case will be covered by the new component. 

Regards,
Atanas Georgiev
Telerik

 

 

[José Angel]

[quote]Atanas Georgiev said:Hello Darshan,

At this point paste from excel capability is not supported out-of-the-box. You can vote for the following UserVoice idea, which we will consider for future releases. 

The closest suggestions we can offer at this point are:

http://docs.telerik.com/kendo-ui/web/grid/how-to/copy-from-excel-to-grid - for KendoGrid
http://www.telerik.com/forums/copy-from-excel-sheet-and-paste-it-in-radgrid - for RadGrid

Regards,
Atanas Georgiev

[/quote]

Atanas, 

Your answer seems to be working except when the grid has a toolbar and p.e. no data. 

Imagine the scenario: http://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/copy-from-excel-to-grid

Now try your method with a empty datasource and toolbar: ["create"]

The jQuery selector will select as well the the toolbar causing a button malfunction.
And since there is no data you can't select and paste on "k-grid-content" class

 

[Rosen]

Hello José,

I'm afraid I'm not able to re-create anything unusual using the provided information. Please take a look at this short video which make the mentioned changes to the test page. Maybe I'm missing something obvious.

Also you should be aware that the how-to articles are not a production ready features, but simplified examples of how-to implement scenarios which are not built into the widget or highlight certain use cases. Their purpose is to inspire you to further improve the idea shown in the sample and incorporate it in your own application.

Regards,
Rosen
Telerik

 

 

[tarun]

Hi Team,

I want to create functionality to copy data from excel sheet and Kendo grid which i have achieved after refer above examples, but i have an one query that is after copy and paste data to Kendo grid how can i save the Updated kendo grid to the database.

thanks

[Alex Hajigeorgieva]

Hello, Tarun,

We have a more complex example which explains how you can achieve the desired outcome of copying and pasting and updating the Kendo UI Grid data source as well. You can find it here:

https://docs.telerik.com/kendo-ui/knowledge-base/grid-paste-data-from-excel-batch-edit

Let us know in case you have further questions once you have reviewed it.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik