This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » OO, Patterns, UML and Refactoring
Bookmark "complex excel report generation" Watch "complex excel report generation" New topic
Author

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.

Thanks
Nachiket Patel
Ranch Hand

Joined: Sep 16, 2007
Posts: 110
whoa,
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: http://aspose.com/file-tools
 
subject: complex excel report generation
 
Similar Threads
Windward Java Engine Review
merging Excel sheets using jxl
Can we make Java web report just by drag and drop?
Suggestions on Handling Report Requests
E-mailing functionality in Java