Free Support Forum -

Exception when refreshPivotData

Workbook wb = new Workbook("/Users/admin/Me/xx.xlsx");

WorksheetCollection worksheets = wb.getWorksheets();

for ( int i = 0; i < worksheets.getCount(); i++) {

Worksheet worksheet = worksheets.get(i);

ChartCollection charts = worksheet.getCharts();

for ( int j = 0; j < charts.getCount(); j++) {

Chart chart = charts.get(j);

if (chart.getPivotSource() != null && chart.getPivotSource().length() > 0) {




} (102.5 KB)

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47235 - NullPointerException when refreshPivotData

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47235”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v20.3.2 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.3.2 For .Net2_AuthenticodeSigned.Zip (5.3 MB)
Aspose.Cells20.3.2 For .Net4.0.Zip (5.3 MB)