wood burning stoves
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 REST with Spring (video course) this week in the Spring 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: 42959
Check out POI and jExcelAPI; those are the only notable free Java libraries that can work with Excel files. They're linked on the http://faq.javaranch.com/java/AccessingFileFormats 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: http://aspose.com/file-tools
subject: Any free Pivot Table Lib?
It's not a secret anymore!