Mar 22, 2013 9:28:00 AM by Debbie Peabody
This is a companion discussion topic for the original entry at https://blog.toadworld.com/2013/03/22/toad-data-point-automation-series-2-exporting-to-excel
This is a companion discussion topic for the original entry at https://blog.toadworld.com/2013/03/22/toad-data-point-automation-series-2-exporting-to-excel
I have a automation script with multiple select statements and the output gets saved into a single workbook -multiple sheets. I would like to rename the sheets and don’t see an option to do in under Select to File activity -Export Options or Export Wizard template options. I am using TDP 4.2 & 4.3 version.
Please advise
Thanks
Sunitha
Rename your worksheets in the output file, and then in the Advanced Export Properties window define the worksheet name for each select statement by clicking on Advanced Properties in the Export File subsection.