I am unable to view the PivotTable I created when I save my file as the FileFormatType of Excel2007Xlxs. Am I missing something or does Aspose.Cells not support PivotTables in Excel 2007? The following is my code used to create the PivotTable and save the file:
Worksheet ws = wb.Worksheets.Add("PivotTableData");
int pti = ws.PivotTables.Add("Sheet1!A1:G" + row.ToString(), "A2", "M");
PivotTable pt = ws.PivotTables[pti];
pt.AddFieldToArea(PivotFieldType.Row, 0);
pt.AddFieldToArea(PivotFieldType.Row, 1);
pt.AddFieldToArea(PivotFieldType.Row, 2);
pt.AddFieldToArea(PivotFieldType.Row, 4);
pt.AddFieldToArea(PivotFieldType.Row, 3);
pt.AddFieldToArea(PivotFieldType.Data, 5);
pt.AddFieldToArea(PivotFieldType.Data, 6);
wb.Save(".\\Report.xlsx", FileFormatType.Excel2007Xlsx);