Specify Excel Export Options

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. This dialog opens when you click Export Options, Export, or Export All in one of the tools listed above.

To specify Excel worksheet options when using the Export Wizard, see Export Data with the Export Wizard.

To specify Export options

1. Click Export Options, Export, or Export All (depending on the tool) to open the Export options dialog.

2. 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. More About Excel Export Options about using the Overwrite option.
   Add Date/Time suffix	Suffix—Select a date or datetime suffix to append to the file name. More About Excel Export Options 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.