Posts
415
Comments
233
Trackbacks
42
Working With Office Open XML

If you haven’t heard of Office Open XML don’t be surprised.  I hadn’t until a couple of months ago.  In short it is a standardization of the Office document models which allows for more flexible development methods.  You no longer need to have an instance of your target Office application running on a server in order to generate Word, Excel or PowerPoint documents.  This is also the reason that all of the Office file extensions have a “x” suffix these days.

Office Open XML files are actually zip files.  This is to allow verbose XML files and required associated documents to be kept as a single package instead of in a binary format.  Given that we are talking about XML files in a zip archive, you can really program against Office Open XML documents simply by knowing the schema definition.  But who wants to do that if someone has already given you a strongly typed API library?

This is where the Open XML SDK 2.0 comes in.  This library gives you strongly typed classes which represent the parts that make up documents.  This in turn makes reading you code easier than simply using a XMLDocument to modify the file.

When working with the XML of a document I have found it hard to find a compact reference of element types.  Of course you can always refer to the verbose ISO standards document (all 5572 pages worth).  Going forward I hope to have some helpful tips for working with the powerful but under-documented technology.  Stay tuned.

posted on Monday, October 19, 2009 2:46 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Comment *  
 

Tim Murphy

Tim is a Solutions Architect for PSC Group, LLC. He has been an IT consultant since 1999 specializing in Microsoft technologies. Along with running the Chicago Information Technology Architects Group and speaking on Microsoft and architecture topics he was also contributing author on "The Definitive Guide to the Microsoft Enterprise Library".



I review for the O'Reilly Blogger Review Program



Technorati Profile

www.flickr.com
Tag Cloud