How to set excel sheet name in BIRT API?

Question

When I use birt api to export excel, the excel's sheet name is default set to Sheet0. Is there a way to custom sheet name in birt API?

Answer 1

I had a report with two table and page break after the first one so each table made their own sheet. after selecting each table go to the script and in the "on create" script, code this: this.name = "Sheet Name";