February, 2012

Quick techniques for finding the Open XML that you need....

This is the fifth in a series of screen-casts on getting started with Open XML development. In this screen-cast, I discuss some of the most important developer techniques that you can use with Open XML development. The simplest technique is modifying...

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. Here is the complete...

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. Here is the complete list of screen-casts in this series: Getting...

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