How to generate multiple sheets in Excel (xls) using BIRT 4.2 ?

Dev90
edited February 11, 2022 in Analytics #1

I have three different tables in the designer and configured three different Master pages for it. When I generate the report in XLSX output, I get the output in three different sheets. But when I generate the report in xls format, all the tables appear in the same sheet in Excel. Could you help me on how to split the data in multiple sheets in BIRT 4.2? I am trying to generate using BIRT Eclipse.