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

Free Support Forum - aspose.com

Pivot table and charting woes!

I’ve had some problems with Pivot Charts which have gotten worse because the Mac OS version of Excel doesn’t even support them! (Original problem here: Missing field buttons in Pivot Chart )


For this reason I’ve decided to just create standard charts, from the pivot table data. I’m struggling to actually extract the data though.

For example, if I try to read a cell, which may be a pivot column name, it return as “” / isNull. In the generated file I can happily put in the equation “=C4”, referencing the same cell as in code, and Excel will return the value.

Hi,


Well you need to refresh PivotTable report to calculate its data before reading data from the PivotTable, see the sample lines of code for your reference:
e.g
Sample code:

pivotTable.RefreshData();
pivotTable.CalculateData();


Hope, this helps you a bit.

Thank you.