File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Any free Pivot Table Lib?" Watch "Any free Pivot Table Lib?" New topic
Author

Any free Pivot Table Lib?

Wei Geng
Greenhorn

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?

Thanks!

Wei
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42371
    
  64
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.


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

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?