I am currently working on the automation of Excel, and add such I have made a good use of the Apache POI library.
As I have so much data stored in my excel workbook in various columns, that I'm trying to create a pivot table.
Is there any way to create Pivot tables using POI ?
My requirement is that I need to create the pivot table in a new excel workbook or in the same workbook where I store my data.
Best Answer
The 'Quick Guide' is quite out of date.
The change log refers to this bugzilla issue as resolved.
You can see the code here:
Here is a snippet: