[Advanced Excel] Renaming 'Sheet1' after using RecordListToExcel

[Advanced Excel] Renaming 'Sheet1' after using RecordListToExcel

  
Forge Component
(21)
Published on 5 Nov (4 weeks ago) by João Rosado
21 votes
Published on 5 Nov (4 weeks ago) by João Rosado
We recently had to export some data. The scenario was simple enough for using RecordListToExcel, but the file would then be imported into an external system, and this system was looking for a specific sheet name. Since RLToExcel always generates a predefined name (Sheet1), the user would have to manually rename the sheet in order to upload it.

We then used this component just to rename the worksheet (after it's generated by RLToExcel). It's actually pretty straightforward, but I'm leaving the screenshots below in case it may help others. Cheers!

Excel_RenameSheet action (input params: binary data, text; output: binary data):


Action content: