Copy from Excel and Paste to Grid

6 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. UI for ASP.NET Ajax is Ready for VS 2017
  4. David
    David avatar
    159 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?
  5. Kostadin
    Admin
    Kostadin avatar
    1711 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.

     
  6. David
    David avatar
    159 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
  7. Kostadin
    Admin
    Kostadin avatar
    1711 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.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017