Definition and Usage
This command copies content from a specified range in an Excel worksheet. It allows you to extract data from a single cell, an entire row, a column, a specific range, or an edited range within the worksheet.
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 |
Copy range | Select the type of range to copy from the Excel file | Cell, Row, Column, Range, Edited range | Yes |
|
Row | Specify the row number |
| Conditional | Required when Copy range is "Cell" or "Row"; Use 1 for first row, -1 for last row |
Column | Specify the column |
| Conditional | Required when Copy range is "Cell" or "Column"; Use number (1 = first, -1 = last) or letter (A, B, C) |
Start row | Specify the starting row number |
| Conditional | Required when Copy range is "Range"; Use 1 for first row, -1 for last row |
End row | Specify the ending row number |
| Conditional | Required when Copy range is "Range"; Use 1 for first row, -1 for last row |
Start column | Specify the starting column |
| Conditional | Required when Copy range is "Range"; Use number (1 = first, -1 = last) or letter (A, B, C) |
End column | Specify the ending column |
| Conditional | Required when Copy range is "Range"; Use number (1 = first, -1 = last) or letter (A, B, C) |
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
Parameters marked with {x} icon can accept variables. You can insert previously created variables into these fields by clicking on the {x} icon and selecting the desired variable. This is particularly useful when you need to dynamically determine row or column values based on previous operations.
Notes
Before using this command, ensure that a valid Excel instance has been created and the target file is open.
The "Copy range" parameter determines which other parameters are required. For example, if "Cell" is selected, you'll need to specify both Row and Column values.
When using "Edited range", the command will copy only cells that have been modified in the current Excel session.
Row and column indices can be specified using positive numbers (counting from the beginning) or negative numbers (counting from the end).
Column references accept both numeric values (1, 2, 3) and alphabetic notation (A, B, C).