This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Any free Pivot Table Lib? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Any free Pivot Table Lib?" Watch "Any free Pivot Table Lib?" New topic

Any free Pivot Table Lib?

Wei Geng

Joined: Dec 10, 2004
Posts: 28
Hello, everyone.

Does anybody know where can I find a free lib which is able to deal with the Excel Pivot table?

In my project, I hope to manipulate the Excel data to generate pivot table with the implement of pure java, instead of VBA.

I had ever search on google, but most of lib's are not free. Can anybody introduce a toll-free one?


Ulf Dittmer

Joined: Mar 22, 2005
Posts: 41069
Check out POI and jExcelAPI; those are the only notable free Java libraries that can work with Excel files. They're linked on the page. I'm not sure what either can do with Pivot tables, specifically, though.

Ping & DNS - my free Android networking tools app
Wei Geng

Joined: Dec 10, 2004
Posts: 28
Yes, POI is a great project that implement the excel operation with Java. However, there was still a weak point for POI. POI can 'operate' the 'existing' Pivot table, but not 'create' a new pivot table in the excel file.

It is the reason why I hope to find a new free lib.

Thank you anyway.

I am looking forwards more answers for my question...
[ October 15, 2008: Message edited by: Wei GENG ]
subject: Any free Pivot Table Lib?
Similar Threads
displaying jsp filename to downloading file in internet explorer
GWT Pivot table component?
JSF Pivot Table
pivot table and chart
Pivot axis