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