January, 2012

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