This video continues where the previous video ( Overview of the Open Packaging Conventions - Part 1 ) leaves off. In this screen-cast, I cover relationship types, relationship ids, internal/external relationships, explicit/implicit relationships, and...

As Open XML developers, we need to know a certain amount about how the markup is stored in ZIP files. This screen-cast is the first of two on Open Packaging Conventions (OPC). In this screen-cast, I cover some of the preliminary basics. In the next screen...

This will probably be the final installment of this series. In this example, I complete the pivot table creation process by configuring the fields that will appear in the rows, columns, filters and data values. This example builds upon the earlier examples...

At last I have put together an example that shows the full range of cell style options available in SpreadsheetML. This example will show how to apply a huge variety of styles using very simple code. The video explains how to use the code and also how...

If your company uses one specific Office theme for one reason or another, you can enable higher fidelity transformations from Open XML WordprocessingML to Html. You can configure the HtmlConverter class to use the styling of one of the Office themes in...

One of the recurring problems that comes up for Open XML developers is that of doing interesting manipulation of paragraphs and runs. Too often, however, you need to split runs here and there to insert the markup you want to insert to achieve the goals...

This is a real-world scenario - you need to implement some sophisticated manipulation of Excel tables in VBA, and then you need to extract the data from the Open XML spreadsheet using the Open XML SDK. This screen-cast was based on a real-world project...

Sometimes you want to place an image on a worksheet. You want to be able to control exactly where the image is, its size, and in most cases, you want to preserve its aspect ratio. The following screen-cast walks through the markup for placing an image...

Sometimes you need to calculate the cell sizes (in pixels) exactly in an Open XML spreadsheet. The most common use case is when placing graphics on a worksheet. You also need cell sizes in pixels when placing controls. In addition, understanding exactly...

This example looks at a couple of OpenXML spreadsheet topics. I have been working with the cell styles a lot lately and this is a first example showing how to add some of the named styles to a spreadsheet cell. I plan to include even more style options...

In a previous screen-cast, I showed the basic steps to customize a ribbon and call a VBA function from the XML that defines the customization. In this video I go one step further - I show a more interesting ribbon customization, and I show how to deploy...

Learn how to take advantage of using ISO dates in spreadsheets

...

Sometimes an end-to-end solution requires some level of customization in the operation of a word-processing document or a spreadsheet. Of course, this is where VBA can be useful. Sometimes the best solution requires a combination of developer techniques...

This is the sixth in a series of screen-casts on getting started with Open XML development. In this screen-cast, I continue the discussion about some of the most important developer techniques that you can use with Open XML development. In this screen...

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

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