Definition and Usage
Delete row from Excel allows you to remove a specific row from an Excel worksheet. This command is useful for data cleanup operations, removing obsolete entries, or dynamically modifying spreadsheet content during workflow automation.
Parameter Values
Input parameters
Parameter | Description | 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 | Must reference a previously created Excel instance |
Worksheet name | Specify the worksheet name (leave blank for the active worksheet) | No | If left blank, the currently active worksheet will be used |
Target row | Specify the starting row number. Use 1 for the first row, or -1 for the last row | Yes | Positive integers for specific rows; -1 to target the last row |
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 to dynamically determine which row to delete based on previous calculations or user input. When using variables, ensure that the variable type matches what's expected by the parameter (e.g., a numeric variable for the target row).
Notes
Before using this command, ensure that a valid Excel instance has been created using either "Launch Excel" or "Get active Excel worksheet" command.
Deleting a row will shift all rows below it up by one position, which may affect formulas or references in your worksheet.
If the specified worksheet does not exist, the command will result in an error.
Row numbering in Excel starts at 1, not 0.
Be cautious when deleting rows in worksheets containing formulas, as this may break cell references.