12

I am trying to start working with Excel documents through the OpenXML SDK Spreadsheet API. But I haven't found any good guides or even examples on how to create a xlsx file from scratch. Only how to open an existing document and modify it.

I have been thinking on having a empty template document and make a copy of it an then begin my proccessing on it. But it doesent feel right. It might be easier but I not comfortable using a technique I dont feel that I understand "pretty" good at least.

So my question is: Does anyone have any good tips on articles or books or any other type of resource that explains the API?

Thanks in advance. /johan

Sildoreth
  • 1,883
  • 1
  • 25
  • 38
jmw
  • 2,864
  • 5
  • 27
  • 32
  • Please use the 'excel-2007' tag rather than 'xlsx'. Watch the suggestion prompts when tagging your questions: any tag with a number less than 10 after it's name is probably wrong. – Joel Coehoorn Jun 05 '09 at 15:09
  • 2
    to me, excel-2007 implies Microsoft Office interop. Since the OpenXML standard does not rely on Excel at all, I think SpreadsheetML is a better tag. – foson Jun 29 '09 at 16:03

4 Answers4

14

Your best bet is to download the OpenXml SDK 2.0 and install. Once installed, check the Tools directory for a tool called DocumentReflector.exe. Using this tool you can "crack open" an existing xslx document (or docx or pptx). Once opened, the application will show you a treeview of the parts, a panel with the xml for a given part and the code required to generate the document from scratch.

This should give you a great start and get you to really understand the SpreadsheetML syntax (I used this tool to learn WordProcessingML and it REALLY helped!).

Also see how to create and download excel document using asp.net

Community
  • 1
  • 1
Pete Skelly
  • 775
  • 6
  • 16
  • I ended up using Synfusions XlsIO component, it a commercial component but money well spent. Recommended for XLSX and XLX creation. – jmw Mar 14 '13 at 17:27
3

I've got to admit. The OpenXml SDK is nice, but there's still a lot to creating a blank spreadsheet.

However, there is a set of Helper Classes available on codeplex called simpleooxml

Very little in the way of documentation, but this blog post shows how to create a new spreadsheet without having to have an existing template.

I've found it works pretty well.

davewasthere
  • 2,988
  • 2
  • 24
  • 25
2

http://openxmldeveloper.org is a pretty good resource, with concepts and code samples in various programming languages

Rad
  • 8,336
  • 4
  • 46
  • 45
0

On MSDN there is now pretty good documentation on all the classes, ie: SpreadsheetDocument and a couple walkthroughs like 'how to create a spreadsheet'.

Sogger
  • 15,962
  • 6
  • 43
  • 40