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
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