Skip to main content

Delete row from Excel

Sophie avatar
Written by Sophie
Updated over a week ago

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.

Did this answer your question?