Definition and Usage
Writes a value to a specific cell in a worksheet. This command allows you to input data into Excel cells by specifying the worksheet, row, and column coordinates.
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 |
Row | Specify the row number | 1 for the first row, -1 for the last row | Yes | - |
Column | Specify the column | Number (1 = first, -1 = last) or letter (e.g., A, B, C) | Yes | - |
Value to write | Specify the value to write | - | Yes | - |
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. For example, you might use a variable for the "Value to write" parameter to dynamically write different values to cells based on previous operations or conditions in your workflow. When using variables, ensure that the variable type matches what is expected by the parameter (e.g., numbers for row/column parameters).
Notes
Before using this command, ensure that a valid Excel instance has been created and the target file is open.
If the specified worksheet name cannot be found, the command will result in an error.
If you specify an invalid row or column reference, the command will fail.
This command can write various data types including text, numbers, dates, and formulas.
When writing formulas, make sure to include the equals sign (=) at the beginning.