Description

The EXCEL Remove rows function allows you to remove rows.

Setting it up

To use the EXCEL Remove rows function, follow these instructions:

Once on a process map:

Navigate to the process where you would like to add the EXCEL Remove rows function
Click on the green button’s drop-down (right side of the green button labelled “Process”)
On the menu that appears, click on the “+ Activity” item
From here you can select the EXCEL Remove rows option
Click "Add" once you are done

Parameter	Required	Type	Default	Description
File path	Yes	Text	–	Full path to the Excel file.
Sheet	Yes	Text	–	Name of the target sheet.
Remove by	Yes	Toggle	Conditions	Remove rows by conditions or by specific row numbers.
Conditions	No	Key-Value	–	Column / Operator / Value conditions (when removing by conditions).
Row numbers	No	Text	–	Line-break separated row numbers to remove (when removing by row numbers).
Trim whitespace	No	Boolean	Off	Trim whitespace from values before comparing.
Case insensitive	No	Boolean	Off	Ignore case when comparing values.

This action does not produce any output variables.

Error	Description
Sheet not found	The specified sheet does not exist.

Use conditions to remove rows dynamically based on data, e.g. remove all rows where Status = 'Cancelled'.