Paste to Excel
Paste value(s) or formula(s) into an existing Excel file. This command allows you to paste either:
-
a table (i.e., multiple values) into multiple cells; or
-
an identical single value into multiple cells
-
Choose whether to paste a table or a single value.
-
When pasting a table, enter information about the table you want to paste:
-
Enter the variable that contains the table; and
-
Enter the delimiters that separate each column and row of the table.
When pasting a single value:
-
Enter the variable that contains the value to paste; or
-
Manually enter the value itself.
-
-
Select whether to paste the data as Actual Values or as Formulas.
-
Enter a variable, the path and name of the file to paste into or click Browse and navigate to the folder and choose the name of the Excel file within it that 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.
-
If the selected Excel file is password protected, enter the password.
-
Specify the worksheet and cells into which to paste the data, either:
-
by entering them manually (this method can be particularly useful when you want to use variable values to select cells).
-
Instruct the wizard how to handle any errors encountered.
Read more about error handling.
-
Enable timeout monitoring.
Read more about Timeout Monitoring.
When you select Create a new file if not exists, the worksheet you define here is automatically created as well.
Selecting worksheet & cells directly in Excel
-
Click Select in Excel to invoke the Excel selector.
-
The Excel selector appears with the selected Excel file open behind it.
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.
-
If you are pasting a single value, skip to Step 4.
If you are pasting a table, click directly in the Excel file and select the worksheet (tab) and first cell of the destination range.
-
The worksheet name and cell you have selected will appear in the selector window's Current selection fields.
-
At runtime, the robot will begin pasting at the cell you specified and automatically write to the number of columns and rows required to paste the entire source table.
-
-
If you are pasting a table, skip to Step 5.
If you are pasting a single value, click directly in the Excel file and select the worksheet (tab) and cells you want to copy the value to.
-
The worksheet name and cell range you have selected will appear in the selector window's Current selection fields.
-
-
When you are satisfied with your selection, click OK .
-
The main Paste to Excel window will appear, with the relevant 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.
You don't need Excel installed to use or to run this command unless you are using 'select range' in the command editor.
Entering worksheet & cells manually
-
Specify the worksheet (tab) in which the cells you want to copy are located.
-
If you are pasting a single value, skip to Step 3.
If you are pasting a table, choose one of the three methods below for specifying where to start pasting:
-
Cell address – Designate the first destination cell using "standard" Excel format, e.g.,
A2
(this is the method used by the Excel selector). -
Column/Row – Designate the starting column and row, using numbers and/or letters (e.g., cell C5 could be designated as Column
3
, Row5
or ColumnC
, Row5
). -
Column – Designate the starting column only, and at runtime, the robot will start pasting at that column in the first available row.
-
-
If you are pasting a table, you're done!
If you are pasting a single value, choose one of the two methods below for specifying the cells you want to copy to:
-
Range – Designate the range using "standard" Excel format (e.g., the range from Column A Row 1 to Column D Row 8 is designated as
A1:D8
) -
Column/Row – Designate the starting column and row and the ending column and row, using numbers and/or letters (e.g., cell C5 could be designated as Column
3
, Row5
or ColumnC
, Row5
).
-