Writing Large Excel Files with the Open XML SDK

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…


Parsing and Reading Large Excel Files with the Open XML SDK

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


Open XML SDK + Office Services: Better Together

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…


Leveraging the Power of Word Automation Services and the Open XML SDK

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 not…


Open XML SDK Code behind the Custom XML Markup Detection Tool

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


Document Assembly: Merging Excel, PowerPoint, and Word Content Together

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 showed this…


Extending the Reach of Excel Services with the Open XML SDK

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 is a…


Open XML SDK + Word Automation Services Presentation at PDC

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 can find all my code samples…


Open XML SDK Demos Shown at the SharePoint Conference (SPC)

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…


Finding Open XML Errors with Open XML SDK Validation

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…