By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,932 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,932 IT Pros & Developers. It's quick & easy.

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

P: 4
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?
Nov 16 '06 #1
Share this Question
Share on Google+
1 Reply

P: 14

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.
Nov 16 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.