Read from Excel

[SonicBoomAu]

Hi All,

Does anyone know how I can read from an Excel file?

Any help will be greatly appreciated.

 

[jmcilhinney]

Search MSDN for "automation excel .net" (without quotes).

 

[SonicBoomAu]

Thank you for that wonderful piece of information.

But I am able to send information from VB .net to excel without any problems. My problem is that I can not figure out how to read information in from an Excel document.

I already have search MSDN and was unable to find what I was after.

 

[SonicBoomAu]

More to the point All I need to know is how to connect to the excel document as I can figure out how to get the information out of the cell.

 

[jmcilhinney]

This MSDN topic contains code to open an Excel spreadsheet, run a routine and then close the file and application. It was result number six returned by the search I suggested.

 

[Joe Mamma]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrconexcelobjectmodeloverview.asp

 

[SonicBoomAu]

Joe Mamma,

Thanks for that. It showed me exactly what I was after.