Copy from Excel and Paste to Grid

[Smitha]

Hi,
I wanted to find out if copy from excel to Telerik ASP.net Grid is supported. I am looking for the ability for users to just copy the data from excel sheet in to the grid. And then the grid should be able to update the data to database. To start with, the grid should have rows, but no data in it (Like a blank spread sheet). To this, the excel data will be pasted to. This is a very important feature for my team , so please let me know, if this is possible to be done.
Regards

[Princy]

Hi Smitha,

Please take a look at the below given forum which discusses the same.
copy from excel sheet and paste it in radgrid

Thanks,
Princy

[David]

Is there better solution than some thread from 2010? At least some better example?

[Kostadin]

Hi David,

I am afraid that the feature is still not supported so you can use the approach from the other forum tread since there isn't another one.

Regards,
Kostadin
Telerik

 

 

[David]

This example frankly doesn't work for me either

[Kostadin]

Hello David,

The solution will work in IE since Firefox (and likely others) don't allow access to the clipboard without specifically allowing it. In case you need to support other browsers then IE I am afraid you have to implement a custom solution for them. I would recommend you to search the web for a solution of this issue since there are many ways you can handle it. As a start point you can examine the following forum thread. Also you can use a jQuery plug-in which allow you to copy paste the Excel data in an HTML table. The following forum discuss some of them.

Regards,
Kostadin
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

[Nikolay]

Hello Tarun,

Thank you for the provided information about your case. I have also replied to your formal support ticket with ID 1431072, where you have submitted the same question.

Below I will share the answer here as well:

I believe you need your data remotely bound. Once you set your Grid data as kendo.data.DataSource instance you could call dataSource.sync(), which will save the data item changes.

I have modified the Dojo demo implementing the above approach. Please review it and let me know if it helps you. 

• http://dojo.telerik.com/EzOzeCuY/2

 

Please note, the product you are asking assistance for is pointed as Kendo UI for jQuery, but this forum thread is dedicated for Telerik Web UI for ASP.NET AJAX products. For better tracking of your support history please submit your questions in the support channel that corresponds to the product. 

 

Kind regards,
Nikolay
Progress Telerik