The current version of Aspose.Cells doesn’t support PivotTable that refer to external data sources.
We need to generate a PivotTable connected to an Analysis Services Cube.
The following post : <a href="
says “Related external data sources feature, we will update you soon.”.
Is this feature planned? Will it be a major upgrade?
Also, is it a known issue that Aspose.Cells doesn’t load existing pivot tables in the object model when opening an existing XLS file? I create an Excel file containing a pivot table then load it using Aspose.Cells : oWorksheet.PivotTables.Count is always zero …
This message was posted using Page2Forum from Comparison with Other Solutions - Aspose.Cells for .NET and Java