Toad Data Point 188.8.131.526
In previous versions of TDP - including, I’m fairly certain, earlier beta builds of TDP 3.3 - when using the “Select to File” activity, and choosing an Excel file, it was possible to specify the name of the tab in the Excel file without having to use an Export Template. This was incredibly useful, as it allowed for reports with multiple tabs to be built - each activity exported to the same file, and you could change the name of the tab from the default “Sheet n” to whatever you wished, and even had the ability to use variables from the automation script as part of the tab name!
This was wonderful, awesome! And then TDP 184.108.40.2066 came along and ruined everything.
In TDP 220.127.116.116, the only way to get this precise functionality is to use an Export Template instead of the “Select to File” activity. However, Export Templates tend to be a bit hit-or-miss when it comes to using variables for file names, etc. There are some other issues with Export Templates as well, but they’re not the subject of this post.
Edited to Add: I should’ve tested to make sure that the Export Template supports the same functionality for more than one activity - it does not. I haven’t tested whether more than one Export Template going to the same file will work, but that’s not really the point.
However, I’ve discovered that if you point two or more “Select to File” activities at the same Excel file, they will continue to add new tabs for each activity, but with the default “Sheet n” naming convention.
I would really like to see the previous functionality where the name for the tab could be defined in the “Select to File” activity be restored. It doesn’t make sense to me why it was removed in the first place, and it does seem to violate the - admittedly general - cardinal rule of software development that each successive version should fix the bugs of the past and add additional features - not take away or degrade existing features.