BIP – Update Sheet Name in RTF template for Excel output

Excel output in Fusion BIP can be generated using multiple ways i.e. either using excel template or RTF templates. When you use RTF templates to generate excel output, by default the data is generated in sheet with name “Sheet1:

If you want to rename Sheet1 to user defined value, then use the below expression in your RTF template:

<?spreadsheet-sheet-name: {‘Test’}?>

If you want it be dynamic, use below expression:

<?spreadsheet-sheet-name: {.//NAME}?>

Make the changes in RTF template and upload. The output file generated will have sheet name as Test.