We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Unable to view PivotTable in Excel 2007 format

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);

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Currently Aspose.Cells will keep the pivot data if open/save a 2007xlsx format file. But it does not support to save user added pivot data to 2007xlsx format file.

Thank you.