How to articles for Open XML

Pivot Table

Using ExtremeML to create a Pivot Table

Using PowerTools to create a PivotTable - Part 1

Using PowerTools to create a PivotTable - Part 2

Using PowerTools to create a PivotTable - Part 3

 

Auto-Filter

Use Open XML SDK to add Auto-Filter

NOTE: This does NOT work well in the Excel file you are using for a template. Use code instead.

 

Validating Open XML file

Using the Open XML SDK to validate the file format

 

Working with Dates in SpreadsheetML

Dates in SpreadsheetML

 

Freezing the top row

Discussion on options for freezing the top row

NOTE: You can do this in the Excel file you are using for a template