File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 42965
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.
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 ]
I agree. Here's the link:
subject: Any free Pivot Table Lib?
It's not a secret anymore!