You can export data to Excel from many different tools and locations in Toad, including the following:
When you export to Excel, the Export options dialog allows you to specify Excel worksheet options for your exported data.
To specify Excel worksheet options when using the Export Wizard, see Export Data with the Export Wizard.
To specify Export options
Specify options for the exported file. Review the following for additional information.
Excel—Click to export to an Excel file.
CSV—Click to export to a comma separated values file (.csv).
|File Name||Click to select a file location and enter a file name. In Automation, to use a variable as a suffix, enter the hash symbol before and after the variable name (#VariableName#).|
Select to overwrite the file.
See More About Excel Export Options for more information about using the Overwrite option.
|Add Date/Time suffix||
Suffix—Select a date or datetime suffix to append to the file name.
See More About Excel Export Options for more information about using the Date/Time Suffix option.
For a new file, enter a worksheet name. For an existing file, select the worksheet from the list.
To add a worksheet to an existing file, select Append worksheet from the list and enter a new name.
For an existing file, clear the Overwrite check box to display/enable the list of available worksheets.
In Automation, for a new file, execute the export once to create the file and enable additional worksheet options.
Append worksheet—This option appends a new worksheet to the file. It is the default setting. To add a generic worksheet name (Sheet 1, Sheet 2, etc.) with each execution in Automation, use the default name (Sheet#). To add a timestamped name, use the Append timestamp to named worksheet option (below).
|Append rows||Select to append exported data to existing data on the worksheet. When used in Automation, data is appended with each execution.|
|Clear worksheet data before exporting||
Select to clear the entire worksheet before exporting data.
If you do not select this option, the worksheet contents outside the range of exported data are not cleared.
|Append timestamp to named worksheet||
Appends a date/time suffix to the base name you specify in the Worksheet name field.
In Automation, use this option to append a new worksheet to your report with each execution, while retaining previously exported worksheets. To implement this method, clear the Overwrite check box and do not add a Date/Time suffix to the file name.
|Start export at||Enter the column and row position at which to begin the export.|
See Microsoft Excel Specifications and Limits for a review of Excel row and column limitations.