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.

Continued here:
Parsing and Reading Large Excel Files with the Open XML SDK

Open XML SDK Code behind the Custom XML Markup Detection Tool

On Brian Jones’ blog today, Zeyad Rajabi has posted the source code for the Custom XML Markup Detection tool from my last post.

Continued here: 
Open XML SDK Code behind the Custom XML Markup Detection Tool

Announcing the Release of the December 2009 CTP for the Open XML SDK

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 SDK usability study Open XML SDK tools improvement Full Support for the Office 2010 Open XML Formats With the latest CTP you are able to create, edit, and consume Office generated Open XML formats for either Office 2007 or Office 2010.

Here is the original post:
Announcing the Release of the December 2009 CTP for the Open XML SDK

Announcing the Release of the August 2009 CTP for the Open XML SDK

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 improvements based on your feedback Semantic Level Validation Support Let’s go back to the Open XML SDK architecture diagram I showed you when we first announced the Open XML SDK : As mentioned in a previous post , the April 2009 CTP of the Open XML SDK added schema level validation support for Office 2007 Open XML files

Here is the original post: 
Announcing the Release of the August 2009 CTP for the Open XML SDK

Adding Repeating Data to PowerPoint

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 Open XML SDK.

Original post: 
Adding Repeating Data to PowerPoint

More Open XML Solution Tools

While I finish up another blog solution, this time on importing a table from Word into Excel, I thought I would share some information on two useful tools you guys can leverage when building Open XML solutions. The first tool I want to talk about is the next release of PowerTools for Open XML. PowerTools for Open XML is an open source project on CodePlex , which is entirely based on version 1 of the Open XML SDK.

Here is the original: 
More Open XML Solution Tools

Importing Charts from Spreadsheets to Wordprocessing Documents

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

Go here to see the original: 
Importing Charts from Spreadsheets to Wordprocessing Documents

Removing Comments from a Wordprocessing Document Programmatically

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 such as author name, and hidden text

View post:
Removing Comments from a Wordprocessing Document Programmatically