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.