OpenXML SDK Spreadsheet starter kits

excel sdk openxml openxml-sdk spreadsheetml
jmw picture jmw · May 5, 2009 · Viewed 7.6k times · Source

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

Answer

Pete Skelly picture Pete Skelly · May 19, 2009

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

Related questions

Open XML SDK 2.0 - how to update a cell in a spreadsheet?

I want to update a cell in a spreadsheet that is used by a chart, using the Open XML SDK 2.0 (CTP). All the code samples I have found insert new cells. I am struggling with retrieving the right worksheet. public …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More