It's not a secret anymore!
The moose likes OO, Patterns, UML and Refactoring and the fly likes complex excel report generation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » OO, Patterns, UML and Refactoring
Bookmark "complex excel report generation" Watch "complex excel report generation" New topic

complex excel report generation

manish ahuja
Ranch Hand

Joined: Oct 23, 2003
Posts: 312
Hi All,

Currently I have a task where in there are complex excel reports to generate. I am trying to gauge how feasible it would be to use the popular java excel libraries.
The complexity of these excel reports is something like
1) There will be 7 excel tabs.
2) There will be links in some tabs to other tabs.
3) The excel report will have radio buttons/drop downs based on which the data to display will change.
4) The excel report should support graphs something like dynamic graphs based on the criteria selected.

Do let me know if not java what is the popular approach adopted for complex reports.

Nachiket Patel
Ranch Hand

Joined: Sep 16, 2007
Posts: 110
I think, it's very hard to do using Java.
try to do it from .Net, if possible otherwise
you should look for commercial third party library for MS excel.
But Sorry, i don't know any.

Before software can be reusable, it first has to be usable. - Ralph Johnson
Jimmy Clark
Ranch Hand

Joined: Apr 16, 2008
Posts: 2187
Read BIRT Overview.
I agree. Here's the link:
subject: complex excel report generation
It's not a secret anymore!