Copy from Excel and Paste to Grid

8 posts, 0 answers
  1. Smitha
    Smitha avatar
    7 posts
    Member since:
    Mar 2014

    Posted 03 Mar 2014 Link to this post

    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
  2. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 04 Mar 2014 in reply to Smitha Link to this post

    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
  3. David
    David avatar
    278 posts
    Member since:
    Mar 2014

    Posted 09 Mar 2015 in reply to Princy Link to this post

    Is there better solution than some thread from 2010? At least some better example?
  4. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 12 Mar 2015 Link to this post

    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.

     
  5. David
    David avatar
    278 posts
    Member since:
    Mar 2014

    Posted 12 Mar 2015 in reply to Kostadin Link to this post

    This example frankly doesn't work for me either
  6. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 17 Mar 2015 Link to this post

    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.

     
  7. tarun
    tarun avatar
    2 posts
    Member since:
    Feb 2019

    Posted 24 Sep Link to this post

    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

  8. Missing user
    Missing user avatar

    Posted 27 Sep Link to this post

    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.
Back to Top