I'm evaluating Aspose.Cells for .NET (version 4.8.1) and have some questions about pivot table support. All the examples I can find deal with creating a new pivot table. I can't seem to find any reference to accessing an existing PT other than to set "update on open" and then set the data and data range.
This seems to work fine, but if I try to access the existing PT programmatically, I can't. For example, I have an XLSX workbook (attached) that has simple data on Sheet2 and a pivot table on Sheet1. If I run the code below, pts is 0. Is this the way it's supposed to work? I see the same thing opening an XLS file that has PTs, too.
Workbook workbook = new Workbook();
int pts = workbook.Worksheets.PivotTables.Count;