Open XML SDK 2.0 RTM is live! Find Articles, Videos, Code Samples, and Resources on MSDN

  • Article

I’ve been incredibly passionate about Open XML since it’s early beginnings. I remember back in the day I was very excited about the possibility of generating .NET server-side Word, Excel, and PowerPoint documents. I also had the opportunity to manage the Open XML Format SDK 1.0 documentation release, design a poster, and I also wrote for a few years a series of blog posts and MSDN technical articles about Open XML, the SDK, and how to use it.

Since then, the Open XML Format SDK has evolved significantly proving us a .NET API, documentation, and tools to help us simplify our task of generating documents programmatically.

What is the Open XML SDK 2.0 for Microsoft Office?

The Open XML Format SDK 2.0  is a superset of the Open XML SDK 1.0. In addition to the functionality provided by the Open XML SDK 1.0, it leverages.NET Language-Integrated Query (LINQ) and provides classes to construct and query the contents of parts within a package. You can use functional construction for composing documents, and LINQ queries for extracting information from documents.

The SDK is a collection of classes that let developers create and manipulate Open XML documents – documents that adhere to the Office Open XML File Formats Standard. Because the SDK provides an application program interface that lets developers manipulate Open XML documents directly, they can do so without the need for the Office client products themselves in both client and server operating environments.

Open XML SDK 2.0 for Microsoft Office offers a number of tools and resources to improve programmatic document processing thus making a task of the developer more efficient. The SDK also carries an interoperability improvements for open XML implementers as well as it is  designed to let Open XML developers build high performance client-side or server-side solutions that handle complex operations using only a small amount of program code.

Microsoft has released an RTM version of Open XML SDK 2.0 for Microsoft Office today. If you haven’t already, you can download it and find the online documentation versions here:

ee402630.Download_lg(en-us,MSDN.10)[1] Download the Open XML SDK 2.0 for Microsoft Office This download provides strongly typed part and content classes for use with Open XML documents. https://www.microsoft.com/downloads/details.aspx?FamilyID=c6e744e5-36e9-45f5-8d8c-331df206e0d0
ee402630.Newsletter_lg(en-us,MSDN.10)[2] MSDN Online version of the Open XML SDK 2.0 for Microsoft Office This reference provides strongly typed part and content classes to manipulate Open XML documents. https://msdn.microsoft.com/en-us/library/bb448854(office.14).aspx

Distribution and requirement notes

Open XML SDK 2.0 is freely redistributable by any solution provider implementing the formats.

Office applications are not required to use the Open XML SDK 2.0, and no software purchase is required. Developers can freely use the Open XML SDK to build document processing solutions for Microsoft Office files and for other implementations of the IS29500 standard.

Open XML content on MSDN

I want to use the remainder of this post to provide you all with a run down of most popular Open XML programmability content and detailed links to MSDN Developer Portal pages where you can find lots of articles, videos, and code snippets.

image 

First, the Open XML Developer Center on MSDN provides you with a mix of community content, articles, learning, getting started, and technical content categorized by scenarios and technologies. Here are detailed links to all our top level entry pages:

Downloads Learn Open XML | Getting Started | Articles | How Do I Videos | SDK | Training | Webcasts and Videos

Scenarios Technologies | OPC | Excel | PowerPoint | Word Community
image Second, take a look at our cool Open XML Developer Center on MSDN Silverlight rotator where you can find Open XML Essential resources including latest news about the Open XML SDK 2.0 for Microsoft Office and community resources.
image Next, I would like to suggest that you watch our recently published Deep Dive Open XML and the Open XML SDK SharePoint Conference session. Using Open XML 2.0 you can create and edit documents on the server without needing to resort to COM-based Office automation. This session presents a basic understanding of how to use Open XML 2.0 for creating documents, spreadsheets, and presentations. It also describes how to use the Open XML SDK and other various tools to make your development life easier. This session provides everything you need to start building document automation processes.

 

Finally, if you want to take a deep dive into Open XML technical content, here’s a detailed list of most popular MSDN content:

Book chapter:

Book Excerpt: Chapter 22: Office Open XML Essentials

Code samples:

CG: Sample: Word 2007 Sample: Using Open XML to Improve Automation Performance in Word 2010 for Large Amounts of Data

Sample: 2007 Office Sample: Building a Server-Side Document Generation Solution Using the Open XML Object Model

Sample: 2007 Office Sample: Manipulating Office Open XML Format Files

Sample: 2007 Office Sample: Using the Office Open XML Formats to Support Electronic Health Records Portability and Health Industry Standards

CG: Sample: 2007 Office Sample: Introducing the Open XML Format External File Converter for Microsoft Office

CG: Sample: 2007 Office Sample: Creating Documents by Using the Open XML Format SDK 2.0

CG: Sample: 2007 Office Sample: Open XML File Formats Code Snippets for Visual Studio 2008 Using the Open XML SDK 2.0 for Microsoft Office

Columns:

OfficeTalk: Creating Form Letters in Word by Using Bookmarks and Office Open XML Files

OfficeTalk: Working with In-Memory Open XML Documents

OfficeTalk: Programmatically Update Multiple External Data Connections in Excel 2007 by Using Open XML

Downloads:

Download: SharePoint 2010 Presentation: Deep Dive into Open XML 2.0 and the Open XML SDK 2.0

Download: 2007 Office Presentations: Open XML Training Presentations

Download: 2007 Office System Document: Open XML Developer Map

Visual How-tos (how-to article + video + code sample):

Visual How To: Building Word 2007 Documents Using Office Open XML Formats

Visual How To: Embedding Documents in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office

Visual How To: Adding Images to Documents in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office

Visual How To: Generating Documents with Headers and Footers in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office

Visual How To: Merging Simple Content from Excel 2007 Workbooks and Worksheets by Using the Open XML SDK 2.0 for Microsoft Office

Visual How To: Merging PowerPoint 2007 Decks Together by Using the Open XML SDK 2.0 for Microsoft Office

Visual How To: Using the Open XML SDK 2.0 Classes Versus Using .Net XML Services

Visual How To: Retrieving Content from Different Parts: Explicit or Implicit Relationships in the Open XML SDK 2.0 for Microsoft Office

Visual How To: Searching for Content in Word 2007 Documents by Using the Open XML SDK 2.0 for Microsoft Office

Visual How To: Generating a Word 2007 Document by Using PowerTools for Open XML and Windows PowerShell

Visual How To: Creating a PowerPoint 2007 Presentation from a Folder of Images by Using the Open XML SDK 2.0 for Microsoft Office

Visual How-To: Using XSLT and Open XML to Create a Word 2007 Document

Visual How To: Using XSLT and Open XML to Create a Word 2007 Document

Visual How To: Displaying Open XML Spreadsheet Tables in the Browser Using Silverlight

Technical articles:

Creating Valid Open XML Documents by Using the Validation Tools in the Open XML Format SDK

Introducing the Office (2007) Open XML File Formats

Using the SharePoint Foundation 2010 Managed Client Object Model with the Open XML SDK 2.0

Accepting Revisions in Open XML Word-Processing Documents

Working with Numbered Lists in Open XML WordprocessingML

Working with Numbered Lists in Open XML WordprocessingML

Introducing the Open XML Format External File Converter for 2007 Office System SP2

Editing Data in an Excel 2007 Open XML File with VBA

Creating Documents by Using the Open XML Format SDK Version 2.0 CTP (Part 1 of 3)

Creating Documents by Using the Open XML Format SDK 2.0 CTP (Part 2 of 3)

Creating Documents by Using the Open XML Format SDK 2.0 CTP (Part 3 of 3)

Using Office Open XML to Save Time Without Writing Code

Taking the 2007 Office System Further with VBA and Open XML Formats

Using Office Open XML to Customize Document Formatting in the 2007 Office System

Getting More from Document Themes in the 2007 Office System with Office Open XML

Creating Business Applications by Using Excel Services and Office Open XML Formats

Creating a Simple Search and Replace Utility for Word 2007 Open XML Format Documents

Using Office Open XML Formats to Support Electronic Health Records Portability and Health Industry Standards

Creating Document Themes with the Office Open XML Formats

Inserting Repeating Data Items into a Word 2007 Table by Using the Open XML API

Building Server-Side Document Generation Solutions Using the Open XML Object Model (Part 1 of 2)

Building Server-Side Document Generation Solutions Using the Open XML Object Model (Part 2 of 2)

Manipulating Word 2007 Files with the Open XML Format API (Part 1 of 3)

Manipulating Word 2007 Files with the Open XML Format API (Part 2 of 3)

Manipulating Word 2007 Files with the Open XML Format API (Part 3 of 3)

Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Format API (Part 1 of 2)

Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Format API (Part 2 of 2)

Open XML Bloggers

The cherry on the pie: I also want to provide you links to Microsoft blogs where you can find more news about the latest release of the Open XML SDK 2.0 for Microsoft Office:

Enjoy the RTM version of the SDK and have fun with your document generation scenarios and solutions.