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
-
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.
-
-
Select whether to paste the data as Actual Values or as Formulas.
-
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.
-
-
If the selected Excel file is password protected, enter the password.
-
Specify the worksheet and cells into which to paste the data:
-
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.
-
(Optional) Select Enable timeout monitoring.
For more information on timeout monitoring, see Timeout Monitoring.