Renaming Excel Worksheet Tabs

This recipe demonstrates how to rename Excel Worksheet Tabs upon rendering an Excel report template.

Renaming Excel Worksheet Tab

  1. From the Report Template view, click on the ‘Detail’ band.

  2. In the ‘Detail’ band property view, expand ‘Script’.

  3. Add the following in ‘On Layout’:

page.setName("[Desired Tab Name]");

  1. Save the Report Template.

  2. Render out using Excel as the output.

Sample Exercise can be found here:
Rename-Excel-Tab.zip (5.7 KB)