Any updates on this?
This appears to be something to do with the pivot cache.
PivotTable pt1 = oWorkbook.Worksheets[“Sheet1”].PivotTables[“PivotTable1”];
pt1.RefreshDataFlag = true;
pt1.RefreshDataFlag = false;
PivotTable pt2 = oWorkbook.Worksheets[“Sheet2”].PivotTables[“PivotTable3”];
pt2.RefreshDataFlag = true;
pt2.RefreshDataFlag = false;
seems to be fixed now, thanks
The issues you have found earlier (filed as CELLSNET-44206) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
I am still running into the same error and I am using aspose - version 19.4.
Below is my sample code:
Worksheet ws = wb.Worksheets;
PivotTable pvt= ws.PivotTables;
pvt.RefreshDataFlag = true;
pvt.RefreshDataFlag = false;
string fileName = Path.GetFileNameWithoutExtension(importFileName);
string exportFileName = exportLocation + @"" + fileName + “-out.xlsx”;
Is there anyone who can help out with this?
Thanks for the sample code segment.
Please provide your template file or complete runnable sample code (if you are not using any template file and you use code to input data into worksheet and create PivotTable based on it dynamically), we will check it soon.
PS. Please try using our latest version/fix: Aspose.Cells for .NET v19.4.x (if you are not already using it).