wants to copy an excel data and paste it in a data grid (very urgent)

[veera372]

hi this is veera, i wants to copy a data from an excel and paste it into a data grid in the web form (asp .net) by clicking the button paste... i think it can be done in java script using clipboard option... but i dont know java script... can anyone help me?

[NewGuy]

http://www.activewidgets.com/

This grid is populated using an array. However, this grid is dynamic in the fact that it will grow with the amount of data inserted. (@20,000 row)

Excel sheets when saved as a text file instead of .cvs will give you a quick backdoor to how to format.

Ex. Save your excel sheet as a .txt. Then open the sheet up in notepad. Pay attention to the format it gives. You can parse the data and put it into an array which can then populate the grid. This is not the most poetic way but will work.