Refresh Pivot table using Apache POI
apache-poi, aspose, excel, java, pivot-table
Solution
Kindly follow the followings which i did.
- Fill rough data for pivot table in your MyFileName.xlsx file.
- Create a Dynamic Range Formula through `OFFSET()` or `Named Table` as Source Data for Pivot table and draw pivot table.
Simply Right click your pivot table and choose
`pivotTable Options->Data-> Check Refresh Data when opening File`
Open a `MyFileName.xlsx` file and fill out the data.
That's all... whenever you opening workbook it will be refreshed to current data. :-)
Note: This will not work when you creating Pivot table through POI.
Problem
No/Minimal documentation regarding Apache POI for Pivot tables in the Apache site has got me to write this. I want to refresh a pivot table in a Work Book using Apache POI. Please let me know where I can get proper documentation and Examples regarding this.