Jxcell does not support pivot table creation (as per their feature list). Besides, I was looking at a more inexpensive solution!
Main Topics
Browse All TopicsI have a Flex 3 application with Java as backend. The application has OLAPDataGrid whose data needs to be exported into Excel as a pivot table. Is there a free library available in Java that can help me do this? I get an ArrayList from the application at the backend that I will need to use and create a pivot table in an XLS file.
I have explored POI 2.5+ for this functionality in vain. I also tried SmartXLS, but that only helps reading a pivot table, not creating one. The OLAPDataGrid does not have fixed set of row and column headers and therefore I cannot use a predefined XLS file as a template file and then edit it programmatically through POI. I will always get different row and column sets and therefore I will have to construct the pivot table freshly each time.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Have a look at this thread - http://www.experts-exchang
See if this satisfies your need.
I figured out the solution myself. It turns out that pivot table is supported from POI 3.5 onwards. The class to look for is org.apache.poi.hssf.record
Business Accounts
Answer for Membership
by: lorendaPosted on 2009-07-29 at 12:02:00ID: 24973413
Never tried it - but here's a link. It says it can do everything you need
tion.com/j xcell.htm
http://www.sharewareconnec