|
-
Apr 15th, 2010, 11:44 AM
#1
Thread Starter
Addicted Member
another read from excel question
Hi gurus
I need to read information from excel and them put them into a text file,I have the part for text file done and write to it but I dont know how to go and read from an excel file where every row is a diferent record, so I need to read the entire row and put every cell on variables so I can get my fixed text file done.
Hope I make sense with my english 101
Thanks a bunch gurus
VS2003
-
Apr 15th, 2010, 06:02 PM
#2
Re: another read from excel question
Hello
First you need to add reference to the Excel, project properties, add reference, microsoft.office.interop.excel, then you need to instantiate a new class of the excel, add vars to the workbook and to the worksheet, then just interact with the cells that you need.
Samples HERE AT MSDN
Good luck
Rate People That Helped You
Mark Thread Resolved When Resolved
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|