Create Excel 2007 files

[BlackSun]

Hi,
I'm using VB2008 and I would like to know how I can create Excel 2007
files without having Office installed on my pc.

OOXML is the rigth direction?
Can you give me any link?

Thanks in advance,
Cheers BlackSun

 

[Joe Cool]

Hi,
I'm using VB2008 and I would like to know how I can create Excel 2007
files without having Office installed on my pc.

OOXML is the rigth direction?
Can you give me any link?

I have done this using the Microsoft Jet OLEDB driver.

 

[eBob.com]

I've done it using something called an "Interop Assembly."

Bob

Hi,
I'm using VB2008 and I would like to know how I can create Excel 2007
files without having Office installed on my pc.

OOXML is the rigth direction?
Can you give me any link?

I have done this using the Microsoft Jet OLEDB driver.

 

[Tom Shelton]

Hi,
I'm using VB2008 and I would like to know how I can create Excel 2007
files without having Office installed on my pc.

OOXML is the rigth direction?
Can you give me any link?

Thanks in advance,
Cheers BlackSun

I have done a lot of this for Excel 2003, but not with 2007. I believe the
xml is very similar - but, you will probably want to look at the Office 2007
reference schemas found here:

http://www.microsoft.com/downloads/...80-F2C0-4B80-9AD1-2CB0C300AEF9&displaylang=en

The other thing is that the office 2007 files are stored in open package
format - basically, a special zip file. The good news is that the framework
has support for reading/creating these packages - System.IO.Packaging.