• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Any free Pivot Table Lib?

 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
 
If you are using a rototiller, you are doing it wrong. Even on this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic