Announcing the New Open XML Object Model – CTP


What a day at Tech ED! Today Doug Mahugh announced during his session the new Open XML Object Model and Brian Jones has a must see post in his blog.


The Open XML object model encapsulates many common tasks that developers perform on Open XML packages, so you can perform complex operations with just a few lines of code. As you can imagine, this API is a great time saver for those of you that write code to manipulate Open XML packages using the System.IO.Packaging APIs. I was lucky enough to play with this API some weeks before the release and I strongly recommend that you download your copy and get your hands dirty. I can tell you that with this new API you write ~70% less code.


The following is a partial class diagram of the API.



My dear friend Frank Rice did a fantastic job creating an SDK for the API. We included the previous diagram and some how-to articles that Frank and I wrote J. You can download the SDK and the API from this link: http://www.microsoft.com/downloads/details.aspx?FamilyId=AD0B72FB-4A1D-4C52-BDB5-7DD7E816D046&displaylang=en


Additionally you can find online documentation here: http://msdn2.microsoft.com/en-us/library/bb448854.aspx


Some must see MSDN topics:



Feedback is welcome!


Keep in mind this is a CTP, so we are expecting to get a lot of customer feedback to polish this API into a better one.


If you are at Tech ED, you should stop by at the Open XML File Formats booth. Stephanie, Doug, and I will be happy to chat with you.


If you are not at Tech Ed and are interested in providing feedback, you can submit a post at the Microsoft SDK Open XML MSDN Forum. Additionally, if you want to submit feedback about the documentation, you can use our Wiki enabled articles in MSDN.


Have fun with the API and PLEASE let us know what you think.

Comments (9)

  1. Doug Mahugh says:

    I was so busy with activities related to the announcement of the new SDK yesterday that I didn’t get

  2. Microsoft has announced a new .NET API for working with the Open XML file formats. The SDK for Open XML…

  3. allandcp_ms says:

    Erika deserves a gold star for the work she did to make this discoverable for developers. Awesome! Thank you!

  4. I was just having a look at the Office Developer Center on MSDN and I noticed this blog post from Erika

  5. Fritz Schenk says:

    You fail to mention that Open XML is not a standard – there is an effort by MS to make it an ECMA standard; but this huge document has not been accepted.

    However, there is an existing ISO standard (http://www.iso.ch/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=43485)

    Thanks

  6. I recently got a query from a customer for information on Open XML development and compiled a couple

  7. I recently got a query from a customer for information on Open XML development and compiled a couple

  8. Alejandro Torres says:

    Is there an example to create an Excel Worksheet containing a Pivot Chart/Table report?