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

Free Support Forum - aspose.com

Pivot Tables not loading

I am loading a document via the new Workbook(fileName) method. The document appears to be loading successfully, but for some reason the Pivot Tables are not showing up in the PivotTables collection for theWorksheet (the count is 0). Is this a bug? Am I doing something incorrectly (I am just loading the workbook). I am using v5.1.0.0. I tried both the .net 2.0 and 3.5 versions.

I’ve attached the example we are trying to load. The second worksheet has a pivot table, but is not appearing in the PivotTable collection.


Well, no it is not a bug rather we don’t support this feature yet. Here is the plan for pivot table features:

Before the end of:
1) August 2010: Support for reading Pivot Table from xlsx files.
2) September 2010: Support for modifying the existing Pivot Tables in the template files.

Thanks for your understanding!

Thank you.


We have supported the feature (create, manipulate and refresh Pivot Tables in XLSX (MS Excel 2007 - 2019)) with enhancements in newer versions. We recommend you to kindly give it a try to latest version of Aspose.Cells. Also, see the document for your reference:
Create Pivot Tables and Pivot Charts