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

Free Support Forum - aspose.com

Read Excel PivotTable problem

Dear sir,

Could Aspose.Cells read the PivotTable which created by Excel? I created an excel file with PivotTable then save it. Then, use Aspose.Cells library to read this excel file, but it return the count of PivotTables is 0.

The code:
Worksheet sheet = workbook.Worksheets[0];
int k = sheet.PivotTables.Count;

Many thanks!

Hi,

I am afraid, the feature is under process, here is the latest update/schedule for the pivot table features.

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

Thank you.

@kwokho,

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