Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Pivot tables in Excel using Java

 
Krish Srinivasan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, Can anyone please let me know if pivot tables can be formed in Excel using Java ? Want to know if at all it is feasible. If it is, some pointers on how to.
We have a requirement to generate an excel file that should have the results in the form of a pivot table.

Any clue is appreciated.

Thanks
Krish
 
Winston Gutkowski
Bartender
Pie
Posts: 10527
64
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Krish Srinivasan wrote:Hi, Can anyone please let me know if pivot tables can be formed in Excel using Java ? Want to know if at all it is feasible. If it is, some pointers on how to.
We have a requirement to generate an excel file that should have the results in the form of a pivot table.

Well, my first question would be: what are you using to generate your Excel files?

If Apache POI, then I'd suggest that you should probably search their docs for the phrase "pivot table".

If something more comprehensive, like OpenOffice, then the chances are quite good that you can (although I've never tried it) because their spreadsheet app also allows pivot tables (except that they call them Data Pilots); but you'll probably be limited as to the type of Excel file you can produce. I believe the latest is still Excel 97/2000.

Winston

 
Krish Srinivasan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Winston for your reply.

Well, we have been using JExcel API for all the applications we have done so far. And this requirement is for a new application. So, we can decide which one to go with and that shouldn't be a problem.

I checked Apache POI and that didn't help. I found this in their site. [http://poi.apache.org/spreadsheet/limitations.html]

I haven't heard about OpenOffice but I will check that out.

Right now, I don't see many options to choose from to do this pivot table in Java. There is one called SmartXLS (not an open source) and I am checking that out as well..

Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic