Creating Pivot Tables, Part 3

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 code for creating a pivot table from scratch.

The next step would be to add rows, columns, filters, and data values. If you are interested in code for that, please comment. The code involves a number of steps, but I would be happy to work through it, if there is interest.