Library tutorials & articles
Understanding Open XML
By Matt Nicholson, published on 04 Mar 2008
Developers have long been building applications around Microsoft Office, using its rich API to build complex business solutions. However until now this has usually meant either running Microsoft Office in an unattended server mode, which is extremely resource intensive and not supported by Microsoft, or getting to grips with the binary file format used by the Office applications.
Thankfully the 2007 Microsoft Office system introduces another way in the Office Open XML document format, which is the native file format of Word, Excel and PowerPoint 2007. What makes Open XML different is not only that it is fully documented XML, but also that it has been ratified by Ecma (and submitted to ISO) as an industry standard.
This has several implications. For a start, it means that you can build your applications around Open XML in the confidence that they will still work regardless of what Microsoft may do in future. It opens up the possibility of other word processors and spreadsheet packages being able to read Open XML documents, and it means your applications can directly create and manipulate documents without requiring Microsoft Office running on your servers.
This series of articles is intended to give you a taster for how Open XML documents are structured and how you can code against them using the new Packaging API. It also looks at some of the many things third parties are already doing with this exciting new format.
Thankfully the 2007 Microsoft Office system introduces another way in the Office Open XML document format, which is the native file format of Word, Excel and PowerPoint 2007. What makes Open XML different is not only that it is fully documented XML, but also that it has been ratified by Ecma (and submitted to ISO) as an industry standard.
This has several implications. For a start, it means that you can build your applications around Open XML in the confidence that they will still work regardless of what Microsoft may do in future. It opens up the possibility of other word processors and spreadsheet packages being able to read Open XML documents, and it means your applications can directly create and manipulate documents without requiring Microsoft Office running on your servers.
This series of articles is intended to give you a taster for how Open XML documents are structured and how you can code against them using the new Packaging API. It also looks at some of the many things third parties are already doing with this exciting new format.
Related articles
Related discussion
-
Trouble saving XML format with Macro in Word 2003
by iga (0 replies)
-
How to control IE from VBA
by NaseemAhmed (0 replies)
-
Excel 2007 Error : ' the digital signature is deleted when Excel users tries to save the Master Excel Spreadsheet.'
by jdierkes (0 replies)
-
Excel VBA transposition problem
by KDHTSVAU (2 replies)
-
excell question
by Uncle (11 replies)
Related podcasts
-
LINQ to XML
Scott's been poking around with LINQ to XML and reports his findings to Carl about life with XDocuments and XElements. They also talk about the bridge classes that link (no pun intended) System.Xml and System.Xml.Linq.
This thread is for discussions of Understanding Open XML.