Hi Nuno,

In fact there is no way to control de sheet name in the RecordListToExcel tool. 

But please be aware that the SheetName parameter is not mandatory in the ExcelToRecordList tool. If you leave the SheetName blank, the first sheet of the excel file is read by default (meaning that you will not have the problem of having to force your users to change the sheet name).

Regards,

Daniel Lourenço
OutSystems

Hi Daniel,

Thank you for your input.

In fact the idea was to get some kind of "backup" with only one excel file and with several sheets, one for each entity, but with the flexibility of the user choosing what to backup on the app interface, and backup or restore on that single file.

But the ability to choose the sheet is only available on the XLSToRecordList.

So we can use this to "Bootstrap" the app with one single excel file, but are not able to use the same process to update the file.

Anyway, thank you for your input.

Regards,

Nuno

Old thread that I found looking for a solution for the same problem...
Since I later found a (pretty easy) solution, I'm sharing it here (thread for the Advanced Excel component).

Thanks for sharing, Paulo.

This is great!

Regards,

Daniel