Chat now with support
Chat with Support

Toad Data Point 5.0 - User Guide

Specify Excel Export Options

You can export data to Excel from many different tools and locations in Toad, including the following:

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.

    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.

 

Related Documents