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...

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....

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...

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...

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...

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...

In previous posts, I showed you how to import charts from spreadsheets to a Wordprocessing document and how to import tables from Word documents to spreadsheets . Today, I am going to show you how to import SmartArt from a PowerPoint deck into a Word document. Solution To import a SmartArt...

In previous posts, like Importing a Table from Word to Excel , I showed you how to retrieve content within specific content controls. In these posts, content controls were used to add semantic structure to a document, where this structure aided in retrieving and inserting content. What about other types...

In a previous post, I showed you how to remove comments from a Word file . In today's post, I am going to show you how to accomplish the same scenario, but this time with Excel and PowerPoint files. Excel and PowerPoint have a Document Inspector feature, which is able to remove multiple types of data...

In a previous post, I showed you how to import charts from spreadsheets to a Wordprocessing document . Today, as promised in my last post , I am going to show you how to import a table from a Wordprocessing document into a spreadsheet. Solution To import a table from a Wordprocessing document to...

There have been several requests made by people asking how to import a chart from one document type to another document type. In a previous post, I showed you how to push data into a spreadsheet to create a chart . Today, I am going to show you how to import a chart from a spreadsheet to a Word document...

I just want to let you guys know we are working on some server issues here, which is why some of the previous posts are not showing images or links to source code. This issue will hopefully be resolved soon. In my previous post, I showed you the easy way to assemble multiple Word documents . Today...

As promised in my previous post about reusable methods for manipulating WordprocessingML , I mentioned I would write a post on how to copy a worksheet within a workbook. Note that this blog post talks about copying a worksheet within the same package. Perhaps sometime in the future I will write a post...

One of the more common scenarios related to a Wordprocessing document is the need to sanitize a document in order to remove personally identifiable information. What do I mean by personally identifiable information? Well, I am talking about, among other things, comments, revisions, personal information...

First off I want to thank everyone for leaving comments suggesting future posts about the Open XML SDK. Looking at some of the comments from previous posts , I noticed there were several requests around generating a Wordprocessing document from external data. I have showed you how to accomplish this...