Export multiple scripts to one excel report

Toad Data Point
1

I use TOAD Data point 4.0 Automate to execute two scripts and will export the results to Excel file

The steps are as the following:

  1. Go to Automate

  2. Select file 1 and export the result to Excel file , start export at A1

  3. Select file 2 and export the result to the same Excel file, start export at B1

After running the scripts, only the second files export to excel file

2

Hello Blair,

Can you please clarify - did you uncheck the “Overwrite” checkbox on the Select file 2 activity? Also please note that there is a “Advanced properties” button right next to it where you can further specify export settings - especially the “Append rows” checkbox.

If that does not help you, can you please attach a sample automation script (.tas file) with this problem? If you are unable to attach it here on the forum post, you might want to send it to my email address: martin.holkovic@quest.com.

Thank you

3

Hi Martin,

Thank you ! It works with the following steps:

  1. Go to Automate
  2. Select file 1 and export the result to Excel file ,
  3. Uncheck “Overwrite” checkbox on the Select file 1 activity, and select static sheet name from the list
  4. Check Use column name for a header row, and check Auto fit Column -start export at A1
  5. Select file 2 and export the result to Excel file ,
  6. Uncheck “Overwrite” checkbox on the Select file 2 activity, and select static sheet name from the list
  7. Check Use column name for a header row, and check Auto fit Column -start export at B1