• 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
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Frank Carver
  • Henry Wong
  • Ron McLeod
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Himai Minh

Pivot tables in Excel using Java

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 10780
71
Hibernate Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic