Use the SpreadsheetControl Pivot Table API to create and modify pivot tables in code. - View it on GitHub