Definition and Usage
Paste content into the target Excel file, expanding into cells to the right and downward. This command allows you to paste clipboard content into Excel, with options to specify the starting position and paste behavior.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on |
| Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Worksheet name | Specify the worksheet name |
| No | Leave blank for the active worksheet |
Start row | Specify the row number |
| Yes | Use 1 for the first row, or -1 for the last row |
Start column | Specify the column |
| Yes | Use either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
Paste options | Select what to paste | Default, Value, Formula, Format | Yes | Controls what aspects of the clipboard content are pasted |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables in any parameter field where you see the {x} icon. This allows you to dynamically set values such as worksheet names or cell positions based on variables defined earlier in your workflow. For example, you could use a variable to specify the starting row based on a calculation or user input.
Notes
Before using this command, ensure that content has been copied to the clipboard that you wish to paste into Excel.
The content will be pasted starting at the specified position and will expand to accommodate all data.
If using the "Value" paste option, only the values will be pasted without formulas or formatting.
If using the "Formula" paste option, formulas will be preserved during the paste operation.
If using the "Format" paste option, only formatting will be applied without changing cell values.
The "Default" option will paste all aspects (values, formulas, and formatting) as they appear in the source.