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.
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