How to read a value from a pivot table cell

Aspose.Cells Product Family
1

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

2

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.
3

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.
4

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.