reading excel data through vb.net application

[Guest]

hello,

I need to run a vb.net application in different OSs like windows 2003,
windows 2000, windows 98 etc....
where only windows 2003 have built-in .net framework and to be installed in
others.
The problem is, client do not want to install excel in all the machines
where this application in intended to run BUT need to read an excel file for
data from all the machines.
I coded using OLEDB. but is it possible to read an excel file without excel
installed ?
i mean using VB.NET.
Please tell me how to do it.
Also please tell everything which is to be done to satisfy this requirement.

Thanks in advance

 

[Paul Clement]

¤ hello,
¤
¤ I need to run a vb.net application in different OSs like windows 2003,
¤ windows 2000, windows 98 etc....
¤ where only windows 2003 have built-in .net framework and to be installed in
¤ others.
¤ The problem is, client do not want to install excel in all the machines
¤ where this application in intended to run BUT need to read an excel file for
¤ data from all the machines.
¤ I coded using OLEDB. but is it possible to read an excel file without excel
¤ installed ?
¤ i mean using VB.NET.
¤ Please tell me how to do it.
¤ Also please tell everything which is to be done to satisfy this requirement.

Other than using ADO.NET and Jet OLEDB you would need to have Excel installed to access the Workbook
data.

The only other option would be to use the Office 2003 XML Reference Schemas:

http://www.microsoft.com/office/xml/default.mspx


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)