Excel multiple worksheets creation (Number of worksheets are known at runtime)


In the EXCEL (.xlsx) report creation,

Is there a way to generate multiple worksheets when number of worksheets are know only at runtime.

As I understand from documentation, creating named regions inside the worksheet template is pre-configuration to match with bands so how do create new worksheet without pre-configuration.

Thank you!

Unfortunately, the Reports addon doesn’t support dynamic worksheets creation at runtime. Worksheets are specified statically when creating a report template.

As a workaround, you are able to print several reports by each worksheet and merge reposts into a single XLSX file.