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