1/10/2011 1:06:28 PM
Development
Tony
I've been working with the Open XML SDK for the past few weeks. I'm not going to lie to you, it's a pain in the butt sometimes but once you start to understand the structure of these documents and start building beautiful documents you'll be glad you spent the time.
Here are a couple of great resources:
Open XML SDK Downloads - The Microsoft page with the sdk. Take note! The OpenXMLSDKv2.msi file is all you need to start working with Open XML docs in visual studio, but the OpenXMLSDKTool.msi contains the "productivity tool" which is so very necessary to building your understanding of the SDK. It can look at a document and reverse engineer it to code, and can even compare two documents and give you the "diff" code to change one to the other. This is great for figuring out what exact commands to use to do something. Here is a link to a youtube that shows how to use the tool.
Code Snippet Library - A list of 52 code snippets that will help you do typical functions like get the worksheet of a spreadsheet by name and get a cell by address (as in A2)
I'm writing up a dll with typical functions like creating a spreadsheet from a datatable which i hope to post soon.
Comment