Skip to Content (Press Enter)
2012-03-02 13-17-21
Paulo Ramos
Staff
56Views
0Comments
[Advanced Excel] Renaming 'Sheet1' after using RecordListToExcel
Question
Forge
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset by Carlos Freitas
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:




1
0
14 Jan 2014
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.