PivotTables that exist in a previously-created Workbook are not accessible to the Aspose.Cells API. This is even with Workbooks that have been created with the Aspose.Cells library.
Example:
Workbook book = new Workbook();
book.Open(“C:\temp\book5.xls”);
foreach (Worksheet worksheet in book.Worksheets)
{
Console.WriteLine("* " + worksheet.Name);
foreach (PivotTable pt in worksheet.PivotTables)
{
Console.WriteLine(" - " + pt.Name);
}
}
I would expect all the current PivotTable names to be printed out… but they are not. It only seems that PivotTabkes created in the current “session” are available.