Monday, March 23, 2015

Dynamics AX 2012: Use OpenXML SDK for Excel Export - Part 4

This is the final post on my experience with OpenXML SDK. The previous posts are here: Part 1, Part 2, Part 3.

In this post I'll introduce the Open XML SDK Productivity tool and a couple of extended libraries for OpenXML.

Despite the benefits of OpenXML, there is also a learning curve as it is quite different from working with Excel object model. Luckily, there is help from Microsoft and other developers.

The Open XML SDK Productivity Tool
This is a tool provided by Microsoft to help developers create OpenXML solution. One of it's most useful feature is you can load up a document and get generated C# source code for creating that document.

Here's a link to an 8 mins video showcasing what the Tool does.
This tool can be downloaded for free from Microsoft. For example, here is the download link for the SDK and the tool for OpenXML SDK 2.5.

Wrappers based on OpenXML SDK
Custom libraries are available based on OpenXML SDK. These libraries aims at hiding away lower level details of using OpenXML SDK to simplify the creation of OpenXML documents, without sacrificing performance. I haven't used them as I stick with OpenXML SDK for personal reason. But many developers are finding them very helpful.

ClosedXML - An often updated wrapper for OpenXML, with detailed documentation.
Simple OOXML - adds the DocumentFormat.OpenXml.Extensions namespace to version 2.0 of the Open Office SDK.

So this concluded my series of OpenXML post. For anyone who haven't used OpenXML SDK before I hope these posts encouraged you to give it a try!
This posting is provided "AS IS" with no warranties, and confers no rights.


  1. Hi. Really great job. Hope You are going to carry on writing about this erp system. You've help so much with all Your articles :) Good job :)

  2. Brilliant piece of information,I had come to know about your web-page from my friend in Chennai. I have read atleast 4 posts of yours by now and let me tell you, your blog gives the best and the most interesting information. This is just the kind of information that I had been looking for and I would regularly watch out for the new posts! Thanx a million once again, Regards, AX consultant