Created attachment 31216 [details] Patch for creating PivotTables Patch which makes it possible to create pivot tables. Default configurations are the same as when creating a default Pivot Table in Excel. Known future work: *It's currently not possible to set any specific value to a filter on a column. An example of how to create a Pivot Table is presented in /src/examples/src/org/apache/poi/xssf/usermodel/examples/CreatePivotTable.java
Any chance you could write up a little bit of documentation for this, to go with the example in the patch, to help people learn about it and get started?
Absolutely! I'll get back to you as soon as possible.
Created attachment 31222 [details] Patch for creating PivotTables I realized I had not merged all the latest changes to the patch, so here comes a new one. I'm working on the documentation and hope to get back to you with it soon!
Created attachment 31223 [details] Patch for creating PivotTables
Created attachment 31224 [details] Quick guide of how to create a Pivot Table
Can you please point me to the branch/tag that contains pivot table API ? I can't see it in the 3.10_beta2 release Thanks Alexander
I tried to apply the patch, but it does not apply cleanly neither with the "patch" commandline tool nor in Eclipse, both tools state that the patch is broken. Can you try to recreate the patch once more?
Created attachment 31281 [details] Patch for creating PivotTables
It seems the tool I used in Windows corrupted the patch. This should apply cleanly! (In reply to Dominik Stadler from comment #7) > I tried to apply the patch, but it does not apply cleanly neither with the > "patch" commandline tool nor in Eclipse, both tools state that the patch is > broken. Can you try to recreate the patch once more?
Is there a target release for incorporting this path?
Given the past problems with the patch, it would be great if someone could try to apply it to a recent SVN checkout. Then, report back if it applies cleanly, if it fixes the problems, if it has sufficient unit test coverage etc. That'll greatly speed up the review + applying of it!
Created attachment 31543 [details] updated patch for creating pivottables I took the liberty to update this patch. Now it applies cleanly to latest trunk. I only removed diamond operators (Java 7) and fixed import statement problems. All tests run. The provided example creates a pivot table that opens in Excel 2010 without any problems.
Do you think this patch needs more testing or could it make it to 3.11 beta 1?
Thanks for this, patch applied (with some changes) in r1614684 It would be good to add some more getters to these new XSSF Pivot Table classes, for common things you might want to check, to avoid you having to dive down into the low level CT classes for that. If you / someone else are able to do that, with associated tests, please open a new enhancement ticket and upload the patch!