Naming Excel Sheets when exporting to Excel

I know how to do this in Toad for Oracle however, "--sheetname:" sadly doesn't work in TDP. I'd love a way to rename the sheets through Select to File in TDP automation.

Any clever ideas would be great. TY!

The way I do it is, I have a Toad variable called "SheetName", and within my automation I set that variable to some value. Then, in the "Select to File" task, click the "Activity Input" tab and then click the "Export options" button down in the bottom right corner. Then in the "Worksheet name:" text box put "#SheetName#".

1 Like