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.
posted 7 years ago
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