Toad World® Forums

Export multiple scripts to one excel report

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

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

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