Refresh all

Is there anyway for Aspose.cells Java to refresh all pivot tables and all external datasources?

Hi,


I am afraid, PivotTables can only be refreshed (via Aspose.Cells APIs) if the source data is present in the same workbook/ file, you may try to use the following two methods to refresh data and calculate the pivot table report data accordingly:
i.e.,
PivotTable.calculateData()
PivotTable.refreshData()

I am afraid, currently, Aspose.Cells does not support to retrieve, update or refresh data based on external data sources.

Thank you.

“I am afraid, currently, Aspose.Cells does not support to retrieve, update or refresh data based on external data sources.”

is this function now available?

@TomPrincen,

I am afraid, Aspose.Cells still does not support refreshing the PivotTables with external data source(s). Also, we cannot support this feature for now. If we still have further updates, we will let you know.
A ticket was already logged with an id “CELLSJAVA-42982”.

We are sorry for any inconvenience caused!

@TomPrincen, @edwin.he,

This is to inform you that the issue (Ticket ID: “CELLSJAVA-42982”) has been resolved. The fix/enhancement will be included in the upcoming release (Aspose.Cells v24.11) that we plan to release in the first half of November 2024. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSJAVA-42982) have been fixed in Aspose.Cells for Java 24.11.