In my last post, I showed you guys how to use the Open XML SDK to read and parse large Excel files . Today, I am going to show you how to write large Excel files with the Open XML SDK . Like in the case of reading, the Open XML SDK provides two approaches for writing Open XML files: 1. using the DOM...

I want to thank you guys for leaving blog post requests. Today's post will focus on one of your requests: parsing and reading large Excel files with the Open XML SDK. The Open XML SDK provides two approaches for parsing Open XML files: 1. using the SDK DOM , 2. using the SAX-like reading/writing capabilities...

In a previous post , where I announced the release of the Open XML SDK 2.0 , I promised to give you guys a list of improvements and breaking changes made to the SDK compared to the December 2009 CTP . We made a few tweaks to the SDK based on some of the great feedback we received from you guys. The...

This post will represent the most up-to-date blog map for topics on the Open XML SDK. Open XML SDK Basics Topic Description Open XML SDK… the Basics Learn about classes of the SDK and their first class properties. This post is a great introduction to the Open XML SDK. Traversing in the Open XML DOM Learn...

Today, I am really excited to announce the worldwide availability of the Open XML SDK 2.0 for Microsoft Office ! The Open XML SDK plays an integral part in creating Office document solutions that work on the client or server. The Open XML SDK allows you to create, consume, and manipulate Open XML files...

I am probably starting to sound like a broken record, but I am really excited about the different types of solutions that are possible when combining the Open XML SDK with Office Services. In the past, I showed you how to leverage the Open XML SDK to accomplish three main scenarios: Push data into Open...

Have you ever wanted to update page number fields or a table of contents within Word documents on the server? The Open XML SDK provides functionality that allows you to easily add or remove content within a Word document. However, as mentioned in the announcement of the Open XML SDK 2.0 , the SDK does...

Recently on Gray's blog he posted about a scanning tool that can be used to detect custom XML markup in Word Open XML files (*.docx, *.docm, *.dotm, and *.dotx). The tool is built using the Open XML SDK and we wanted to take the opportunity to show you how the solution works in this blog. Solution The...

Document assembly seems to be a hot topic these days especially when combined with the power of SharePoint. Today, I want to show you a pretty rich document assembly solution that is able to take multiple Word, Excel and PowerPoint documents and merge them all together to form a final Word document....

I'm really happy to announce the 4 th CTP for the Open XML SDK 2.0 for Microsoft Office ! There were four major improvements we made to the SDK: Full support for the Office 2010 Open XML formats Office 2010 schema and semantic level validation General improvements based on a recent Open XML...

Note: Updated post to point to a YouTube video that is shorter than 10 minutes In Brian's last blog he talked about Open XML and Office Services as a one-two punch to complete many types of solutions. I am going to start writing some posts that showcase these two technologies working together. Excel...

I just got back from PDC and am excited to share with you guys the presentation, deck, and code samples I showed at my session . I also want to thank everyone who attended my session. Here is my recorded session: You can find my session deck here: http://ecn.channel9.msdn.com/o9/pdc09/ppt/PR09.pptx You...

I'm pretty excited, next week I'll be at PDC in Los Angeles giving another presentation on the Open XML SDK. I'll be at the conference from Nov 17-19, so if you're at PDC do come by and say hi. Here's the description and time of the session I'll be presenting: Session...

If you didn't see the news up on the Word team blog announcing Word Automation Services, and you have any interest in server side conversion of .docx files into .pdf or .xps, you should definitely go take a look: http://blogs.msdn.com/microsoft_office_word/archive/2009/10/26/introducing-word-automation...

First off, I want to thank everyone who attended my two sessions at SPC on developing solutions on top of the Open XML SDK. The sessions were recorded, so as soon as they are published to the web I will send you guys some links. In the meantime, I want to share with you guys some really cool demos and...

We're just a couple of weeks away before the start of the SharePoint Conference (SPC) being held in Las Vegas. I want to give you guys a heads up that I will be at the conference from Oct 19-22. I'm pretty excited because I will be giving two different presentations on the Open XML SDK at the conference...

In a previous post, I gave you an overview of the functionality added to the Open XML SDK 2.0 August 2009 CTP . Today, I want to deep dive into the schema and semantic level validation support within the SDK. Specifically, I am going to show you guys the Open XML SDK code needed to actually validate...

In my previous post , I announced the release of the Open XML SDK August 2009 CTP . Today, I want to announce the release of the Open XML SDK code snippets . This package of code snippets provides over fifty reusable code samples, in both C# and VB.NET, which accomplish many common tasks involving Excel...

I'm really happy to announce the release of the 3 rd CTP for the Open XML SDK 2.0 for Microsoft Office ! So what did we do in this CTP? Well, there were three main improvements we made to the SDK: Add semantic level validation support Add markup compatibility/extensibility support General...

In my introduction post on the Open XML SDK I mentioned that the SDK is built on top of System.IO.Packaging . System.IO.Packaging is a set of APIs that are part of .NET 3.0, which allow developers to create and manipulate documents based on the Open Package Convention (OPC). Given that Open XML Formats...

In a previous post, I showed you how to create a product catalog in a Word document using the Open XML SDK . I also showed you how to make PowerPoint a reporting application based on data within a database . Today, I am going to show you how to create a product catalog in a PowerPoint deck using the...

Fluent UI, or the Ribbon, was introduced as part of Office 2007 as a replacement of the previous system of toolbars and menus. The Fluent UI technology, like the Open XML formats, is based on xml, which allows for a much richer extensibility story for developers. In Erika Ehril's blog post she described...

In my last post, I showed you guys how to embed an Excel spreadsheet within a Word document without the need to invoke an OLE Server. In today's post I am going to show you how to embed any file in an Open XML file. Specifically, I am going to show you how to embed a PDF file into a Word document. Note...

A couple of weeks ago I gave a presentation on the Open XML SDK to a few customers, where I was asked questions on how to embed files within Open XML documents. I thought it would be a good opportunity to devote a couple of posts around this topic. In today's post I am going to show you how to embed...

In today's post I am going to show you how to remove page and section breaks within a Word document using the Open XML SDK. Removing these two types of breaks is similar, but requires two different approaches. Let's start off by jumping into removing page breaks. My post will talk about using version...