This week's book giveaway is in the Reactive Progamming forum. We're giving away four copies of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams and have Adam Davis on-line! See this thread for details.
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 5 months 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!