Opening Excel and Excel files

dinosaur_uk · September 16th, 2004, 04:35 AM

Hi there,

I am sorry for bothering you guys.

I am using VB.net and need to open applications like excel.
Also i would like to open excel files and play around with the data, what is the best way to do this ? i have tried objReader, but it does not work.

Thank you very much

katsarosj · September 16th, 2004, 01:38 PM

You can start external applications like excel by using:

System.Diagnostics.Process.Start("excel.exe")

As for playing around with the data, you will probably need to pick up a book as there is more to it than the one line of code that I listed above. Excel has it's own object model that you can use and can do that by adding a reference to the Microsoft Excel 9.0 Object Library.

J

Greg Griffiths · September 16th, 2004, 03:00 PM

check out http://www.greggriffiths.org/webdev/both/excel/ which covers this.

dinosaur_uk · September 17th, 2004, 03:22 AM

I dont have the Excel 9.0 Object library,

I have the version 10.0

Will it make much difference ?
Also, where can i get more info about using the object library ?

Been to the website listed above, but it does not work in vb.net 2003

Cheers