This is the forth in a series of screen-casts on getting started with Open XML development. In this screen-cast, I discuss the two most common scenarios around OpenXML SpreadsheetML, and the most important scenario around PresentationML. Getting Started...

The question sometimes arises: why do we need Open XML? In my own words, in the following screen-cast, I identify the seven key reasons why Open XML is an important technology. As I discuss each of the seven reasons, I demonstrate in some fashion or another...

Have you ever wondered how dates in spreadsheets are handled and how it all plays together? This article explains it all along with code showing how to utilize it.

...

If you tried the PowerTools Core code for pivot tables, it may not have worked. I made a mistake in the code that did not cause a problem in Excel 2007, but was a big problem in Excel 2010. In this article, I am going to explain the error in detail, how...

This is the third in a series of screen-casts on getting started with Open XML development. In this screen-cast, I discuss the three most common scenarios around OpenXML WordprocessingML. Getting Started with Open XML Development The first in a series...

One of the interesting scenarios around Open XML is that of extracting data from a spreadsheet. The ability to programmatically retrieve the data from a spreadsheet means that we can use Excel as a powerful tool for maintaining data, and then drive interesting...

This third part of the series is a screencast that explains the Open XML elements needed for a pivot table and how to create the parts and elements needed. Part 1 showed how to create a pivot table using an existing spreadsheet. Part 2 showed the example...

In this second part, I will show the code for creating a pivot table in Excel from scratch using Open XML. This post contains a brief explanation of the example that can be found in PowerTools Core 2.2.2 from Codeplex ( powertools.codeplex.com ). // Create...

Sometimes developers need to create huge spreadsheets, perhaps with 100's of thousands of rows, and many columns. A worksheet that contains 1,000,000 rows and 10 columns will contain upwards of 20,000,000 nodes in the worksheet part. This presents...

Web developers sometimes want to integrate some Open XML functionality into their web application. You may want to enable end-users to upload documents. You may want to modify the uploaded documents, or generate new documents, and you may want to enable...

This is the second in a 2-part screen-cast series on controlling vertical spacing in an Open XML WordprocessingML document. When generating word-processing documents, you sometimes want to control vertical spacing very explicitly. You may want to control...

I've recorded a 2-part screen-cast series on controlling vertical spacing in an Open XML WordprocessingML document. When generating word-processing documents, you sometimes want to control vertical spacing very explicitly. You may want to control...

Updates are available today for two accessibility add-ins built in Open XML that provide tools for people with hearing and print disabilities, STAMP and Save As DAISY for Office 2010. ...

This is a fun little project that I needed to do to help out a customer. The customer needed to select a specific subset of paragraphs in a WordprocessingML document based on certain search criteria, and then display the subset in a form (in a Windows...

This blog post is a request for information. We’re interested in doing a series on how to build with Open XML in the cloud and we want to hear what you are doing and how we can help. Are you developing for the cloud, and does Open XML figure into...