[RESOLVED] Help with OpenXml SDK 2.0 generating a simple Excel file

Hi,

I am using Microsoft OpenXml SDK 2.0 to create Office 2007, 2010 files, specifically a very simple excel file.

It has a simple header which is merged with 6 cells to center. Bold font size 16.
There are 6 columns and each has a header. Bold font size 14.
There are rows of data related to each 6 columns.

I am looking for decent examples of OpenXml SDK 2.0 to get started. If anyone has any experience with it then any help would be very much appreciated. In the mean time I am working on it myself too.

Cheers :)

I'm assuming you've looked here? I myself have never even heard of OpenXML, but that might be a good place to start looking.

Yes I have looked there and already working on finding resources that can help me. The SDK even comes with a tool that can load your excel file and give you .NET Code but that code has just too much crap in it. I am trying to simplfy it.

The reason I want to use OpenXML is so I can write an app that can create Excel.xlsx files without having to reference interop assemblies and thus need to deploy them on the target machine.

Post the code here, we might be able to simplify it.

Thanks for the offer, I really appreciate it.

But I am going to use the Interop for the time being purely due to the fact that there are too many unknowns with the code and our client would rather like to have the application working quickly than invest in time to perfect it without using Interop. We are planning to get Aspose Total .NET Suite anyways so that will solve the problem in the long run but for now it is ok.

Thanks again.