Refresh Pivot Table with Apache POI
apache, apache-poi, excel, java, pivot-table
Solution
You can simple activate an option that will refresh the pivot table every time the file is opened.
This Microsoft documentation says :
In the PivotTable Options dialog box, on the Data tab, select the Refresh data when opening the file check box.
Problem
I'm currently working on a Java application that uses a template excel file that contains a pivot table. The template file also has a data sheet that seeds the pivot table. This data sheet is dynamically loaded in the java application through the Apache POI api. When I open the excel file I must refresh the Pivot table manually to get the data loaded correctly. Is there any way to refresh the Pivot table with the POI api so I don't have to manually do it?