This is a migrated thread and some comments may be shown as answers.

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

7 Answers 394 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Darshan
Top achievements
Rank 1
Darshan asked on 27 Aug 2015, 02:28 PM

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.

7 Answers, 1 is accepted

Sort by
0
Accepted
Atanas Georgiev
Telerik team
answered on 28 Aug 2015, 01:42 PM
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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Darshan
Top achievements
Rank 1
answered on 31 Aug 2015, 03:06 PM
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.
0
Atanas Georgiev
Telerik team
answered on 02 Sep 2015, 10:09 AM
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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
José Angel
Top achievements
Rank 1
answered on 30 Mar 2016, 07:34 AM
[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

 

0
Rosen
Telerik team
answered on 01 Apr 2016, 02:01 PM

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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
tarun
Top achievements
Rank 1
answered on 24 Sep 2019, 11:52 AM

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

0
Alex Hajigeorgieva
Telerik team
answered on 26 Sep 2019, 10:29 AM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Grid
Asked by
Darshan
Top achievements
Rank 1
Answers by
Atanas Georgiev
Telerik team
Darshan
Top achievements
Rank 1
José Angel
Top achievements
Rank 1
Rosen
Telerik team
tarun
Top achievements
Rank 1
Alex Hajigeorgieva
Telerik team
Share this question
or