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

Copy from Excel and Paste to Grid

7 Answers 264 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Smitha
Top achievements
Rank 1
Smitha asked on 04 Mar 2014, 12:48 AM
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

7 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 04 Mar 2014, 11:02 AM
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
0
David
Top achievements
Rank 1
Veteran
answered on 09 Mar 2015, 06:08 PM
Is there better solution than some thread from 2010? At least some better example?
0
Kostadin
Telerik team
answered on 12 Mar 2015, 09:45 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
David
Top achievements
Rank 1
Veteran
answered on 12 Mar 2015, 11:53 AM
This example frankly doesn't work for me either
0
Kostadin
Telerik team
answered on 17 Mar 2015, 06:50 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
tarun
Top achievements
Rank 1
answered on 24 Sep 2019, 12:08 PM

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
Nikolay
Telerik team
answered on 27 Sep 2019, 07:32 AM

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. 

 

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

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
Smitha
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
David
Top achievements
Rank 1
Veteran
Kostadin
Telerik team
tarun
Top achievements
Rank 1
Nikolay
Telerik team
Share this question
or