locked
Drop in excel data RRS feed

  • Question

  • User1002510860 posted

    I am trying to create a form in which I can copy excel data and paste it into a table then interpret the data needed into a form that is manageable.  Basically I have tried a few different approaches to this, but all I want is to basically have a table which can have multiple lines of data pasted in. Then assign variables to the data and then order it in a table. What is the simplest way to get a drop in table?

    Monday, March 23, 2015 1:59 PM

Answers

  • User1918509225 posted

    Hi twistedviper,

    Thanks for your post here.

    For your issue ,i suggetst that you could try to create a gridview to show the data which you copied from excel.

    we cannot paste the copied data from Excel file or Clipboard to GridView and hence we need to paste the data to an ASP.Net Multiline TextBox or TextArea and then populate GridView.

    I suggest that you could try the tutorial which explain how to Copy-and-paste-data-from-Excel-Clipboard-to-GridView-in-ASPNet:

    http://www.aspsnippets.com/Articles/Copy-and-paste-data-from-Excel-Clipboard-to-GridView-in-ASPNet.aspx

    Best Regards,

    Kevin Shen.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 23, 2015 9:34 PM