Specify Excel Export Options
You can export data to Excel from many different tools and locations in Toad, including the following:
- The Export Wizard
- The Export Wizard activity in Automation
- The Select To File activity in Automation
- The Transform and Cleanse tool
- The Clean Data activity in Automation
- The Dimensional Viewer
- The Dimensional Viewer activity in Automation
- The Pivot Grid
- The Pivot Grid activity in Automation
Export Options Dialog
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
- Click Export Options, Export, or Export All (depending on the tool) to open the Export options dialog.
-
Specify options for the exported file. Review the following for additional information.
Option Description Export As Excel—Click to export to an Excel file.
CSV—Click to export to a comma separated values file (.csv).
- Quote character—Enter a character that you know is not included in the quoted strings (cell values).
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#).
Overwrite 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.
Worksheet name 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.