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

Free Support Forum - aspose.com

How to read a value from a pivot table cell

Pls i need to read a value from a cell in a pivot Table. i have tried but the local values when debugging is giving me some value different from the cell when i download the pivot in excel

Hi,


I think you may try to call the following two methods before reading the cell value in the PivotTable report:
e.g
pivotTable.RefreshData();
pivotTable.CalculateData();


Thank you.

Am already calling these functions

pivotTable.RefreshData();
pivotTable.CalculateData();
The challenge is that am trying to fill in the empty cells in my pivot row using the value existing in any of the row. i have to loop or iterate through the pivot rows to get the cell that has value and used it to fill the empty cell. but the problem is that when i inspect my data from my code, am getting strange numbers different from what is in pivot. Is Aspose treating pivot as an object or what? pls this is urgent.

Hi,


Please provide us your sample code (runnable) or preferably a sample console application (you may zip it prior attaching here) to show the issue / problem on our end. We will check it soon. Also attach your template Excel file(s) if you have any.

Thank you.