Delete Row in File

This is a pre-built action located under @Excel element, instructs Avo Assure to delete a particular row in the Excel file based on its row number and save the result in dynamic variable.

Syntax

Input Value: <RowNumber>;RowNumber>(Optional)

Argument	Description
RowNumber (Required)	Provide the particular row number to delete the Row
RowNumber (Optional)	Provide multiple rows number to delete the Rows

Note: You can delete single or multiple rows at a time depending on the input value

Output Value:

Argument	Description
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)	This variable holds the results in True and False

Example 1

Delete a single row from a excel file The Delete Row in File action takes the value from the Input Value column (e.g., 2) and removes the specified row (row 2) from the given excel file. The action status is saved in the {Status} variable with the following possible values:

• True – if the row is deleted successfully

• False – if the action fails

Example 2

Delete multiple rows from a excel file The Delete Row in File action takes the value from the Input Value column (e.g.,3;4;5) and removes the specified rows (row 3,row 4 and row 5) from the given excel file. The action status is saved in the {Status} variable with the following possible values:

• True – if the rows is deleted successfully

• False – if the action fails