Paste to Excel

Paste value(s) or formula(s) into an existing Excel file. This command allows you to paste:

• A table (i.e., multiple values) into multiple cells

• A single value into multiple cells

1. Choose whether to paste a table or a single value.

   Paste a table:

   • Enter the variable that contains the table; and

   • Enter the delimiters that separate each column and row of the table.

   Paste a single value:

   • Enter the variable that contains the value to paste; or

   • Manually enter the value itself.

2. Select whether to paste the data as Actual Values or as Formulas.

3. Choose how to select the Excel file where you want to paste the table or single value:

   • Enter the variable that will hold the path and name of the file where you want to paste the data.

   • Click on Browse to navigate to the desired folder and select the Excel file you want to paste the data into.

   You can select Create a new file if not exists to create a new file from the file name you entered.

4. If the selected Excel file is password protected, enter the password.

5. Specify the worksheet and cells into which to paste the data:

   Select in Excel

   Use this method to select the cells that you want to use from the Excel sheet for your Advanced Command or DAC.

   1. Click Select in Excel to invoke the Excel selector.

      The Select from Excel window appears with the selected Excel file open behind it.

   

   2. Click directly in the Excel file and select the worksheet (tab) and cells you want to use in your Advanced Command or DAC.

      The worksheet name and cell range you have selected will appear in the selector window's Current selection fields.

      If the selector window interferes with viewing or selecting the cells you need, simply drag the window to a more convenient location on the screen.

   

   3. When you are satisfied with your selection, click OK.

   The Advanced Command or DAC window appears with the Worksheet and Range fields populated by your selections.

   If you want to make modifications to your selections, you can do so either manually or by repeating the Select in Excel process.

   

   Enter Excel data selection manually

   Use this method to manually select the worksheet content to be used in your Advanced Command or DAC.

   This approach can be particularly useful when you want to use variable values to select cells.

   1. Specify the worksheet (tab) where the cells containing the desired values for your Advanced Command or DAC selection are located.

      

   2. Choose one of three methods for specifying the cells you want to use from the Excel sheet:

   • Range: Designate the range using a "standard" Excel format (e.g., the range from Column A Row 1 to Column D Row 8 is designated as A1:D8).

   • From/To: Designate the starting column and row, using numbers and/or letters (e.g., cell C5 could be designated as Column 3, Row 5 or Column C, Row 5).

     (Optional) Designate the ending column and row, using numbers and/or letters.

     • If you don't designate an ending column, the robot will copy data from all columns until it detects that it has reached the last column in the range (by reading 20 consecutive empty columns).

     • If you don't designate an ending row, the robot will copy data from all rows until it detects that it has reached the last row in the range (by reading 20 consecutive empty columns).

   • Entire worksheet: The robot will copy data from the entire worksheet until it detects it has reached the last row and column in the sheet (by reading 20 consecutive empty rows/columns).

6. Expand the Error handling option to provide instructions to the wizard on how to manage encountered errors.

   For more information on error handling, see Error handling.

7. (Optional) Select Enable timeout monitoring.

   For more information on timeout monitoring, see Timeout Monitoring.