How to export jasper report as excel workbook with multiple sheets?

[robinbiju8111]

Hi, 

I have some employees and departments. Each department has more than 100 employees. 

I want to design a Jasper report that exports as an excel workbook with list of employees in each department on each sheet. And the sheet name should be dynamically set as the department name.

Thank You.

[Tom C]

https://community.jaspersoft.com/wiki/sample-report-creating-multi-sheet-xls-report-output-subreports

https://community.jaspersoft.com/wiki/sample-report-demonstrating-dynamically-set-sheet-names-excel-output