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

Free Support Forum - aspose.com

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!