I have a problem with apache POI 3.14. I've two workbooks, one with new data and one with old data and a pivot table. My code copies the new data sheet in the workbook with the pivot table, but i don't know how to update the pivot table values.
I'm getting mad with the documentation, i cant figure out how to solve this. Could you please help me?
Disclaimer: I know POI well, but nothing about its handling of pivot tables.
My first question would be: why use such an old version of POI? Since 3.14, at least 3 changes/enhancements have been made to pivot table handling according to https://poi.apache.org/changes.html, described as "Pivot table enhancements", "Support Table (structured reference) sources in PivotTables" and "XSSFPivotTable::addColumnLabel sets the cell type of a cell outside of the source data area", respectively. While it's not clear that those apply to your situation, it might be worth the effort to try the latest released version.
posted 2 weeks ago
Hi Tim, thank you for helping!
Actually, i cant change the POI version, i'm working on an old application and i just can't upgrade the POI version.
If you have any other ideas, would be appreciated!