Definition and Usage
This command allows you to write, insert, or append values to a specific row in an Excel worksheet. It provides multiple options for data entry, including writing to an entire row or to specified columns, making it versatile for various data manipulation tasks within Excel.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance (created via the "Launch Excel" or "Get active Excel worksheet" command) to identify the instance to operate on. |
| Yes |
|
Worksheet name | Specify the worksheet name (leave blank for the active worksheet) |
| No | If left blank, the action will use the currently active worksheet |
Write mode | Specify whether to append, insert or overwrite | Append, Insert, Overwrite | Yes |
|
Row | Specify the row number. Use 1 for the first row, or -1 for the last row |
| Yes |
|
Input mode | Choose how to input data: use Entire row to enter values in order, or Specific column(s) to set values for selected columns | Entire row, Specified column(s) | Yes |
|
Value to write | For entire row mode, select a list or enumerable variable (e.g., a data table row) |
| Yes | Only visible when "Entire row" is selected |
Start column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Yes | Only visible when "Entire row" is selected |
Value to write |
|
| Yes | When "Specified column(s)" is selected, you can add multiple column-value pairs |
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 the parameters of this command by clicking the {x} icon next to the input fields. This allows you to dynamically set values such as worksheet name, row numbers, or the data to be written based on variables from previous steps in your workflow. When using variables, ensure that the variable type matches the expected input type for each parameter.
Notes
Before using this command, ensure that a valid Excel instance has been created using the "Launch Excel" or "Get active Excel worksheet" command.
When using "Append" mode, data will be added after the last row with content in the worksheet.
When using "Insert" mode, existing data will be shifted down to make room for the new data.
When using "Overwrite" mode, any existing data in the specified row will be replaced.
For "Entire row" mode, you need to provide a list or enumerable variable (such as a data table row) containing all values to write.
For "Specified column(s)" mode, you can add multiple column-value pairs by clicking the "+ Click to add" button.
Column references can be specified either as numbers (1, 2, 3...) or Excel column letters (A, B, C...).