SonicBoomAu Posted August 9, 2005 Posted August 9, 2005 Hi All, Does anyone know how I can read from an Excel file? Any help will be greatly appreciated. Quote Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. -- Rick Cook, The Wizardry Compiled
jmcilhinney Posted August 9, 2005 Posted August 9, 2005 Search MSDN for "automation excel .net" (without quotes). Quote
SonicBoomAu Posted August 9, 2005 Author Posted August 9, 2005 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. Quote Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. -- Rick Cook, The Wizardry Compiled
SonicBoomAu Posted August 9, 2005 Author Posted August 9, 2005 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. Quote Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. -- Rick Cook, The Wizardry Compiled
jmcilhinney Posted August 9, 2005 Posted August 9, 2005 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. Quote
Joe Mamma Posted August 9, 2005 Posted August 9, 2005 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrconexcelobjectmodeloverview.asp Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
SonicBoomAu Posted August 9, 2005 Author Posted August 9, 2005 Joe Mamma, Thanks for that. It showed me exactly what I was after. Quote Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. -- Rick Cook, The Wizardry Compiled
Recommended Posts