This recipe demonstrates how to rename Excel Worksheet Tabs upon rendering an Excel report template.
Renaming Excel Worksheet Tab
From the Report Template view, click on the ‘Detail’ band.
In the ‘Detail’ band property view, expand ‘Script’.
Add the following in ‘On Layout’:
page.setName("[Desired Tab Name]");
Save the Report Template.
Render out using Excel as the output.
Sample Exercise can be found here:
Rename-Excel-Tab.zip (5.7 KB)