Delete Row in File

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to delete a specific row in the Excel file based on the row number provided in the Input Value column. The result of this operation is stored in a dynamic variable for further use during test execution.

Syntax

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

Argument	Description
<RowNumber> (Required)	Provide the row number of the Excel file that you wants to delete.
<RowNumber> (Optional)	Provide the multiple row numbers of the Excel file that you wants to delete.

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

Output Value: <Dynamic Variable>(Optional);<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)	Both dynamic variable stores the status as True or False.

Example 1: Deleting a Single Row from an Excel File

In this example, we explain how to delete a specific row from an Excel file using the Delete Row in File action.

• Action: Delete Row in File

• Input Value: 2

  • The row number (2) specifies the row position in the Excel sheet that needs to be deleted. This identifies the exact row (Row 2) in the Excel file that will be removed.

• Output Value: {Status}

  • The execution status of the action is stored in this {Status} variable with the following possible values:

    • True: If the row is deleted successfully.

    • False: If the row is not deleted successfully.

• Logical Explanation: The Delete Row in File action takes the value from the Input Value column 2 and deletes the specified row (Row 2) from the configured Excel file. The execution status of this operation is stored in the {Status} variable as true.

Example 2: Deleting Multiple Rows from an Excel File

In this example, we explain how to delete multiple rows from an Excel file using the Delete Row in File action.

• Action: Delete Row in File

• Input Value: 3;4;5

  • Each row number (3;4;5) specifies distinct rows in the Excel sheet that need to be deleted. This identifies the exact rows (Row 3, Row 4, and Row 5) in the Excel file that will be removed.

• Output Value: {Status}

  • The execution status of the action is stored in this {Status} variable with the following possible values:

    • True: If the rows is deleted successfully.

    • False: If the rows is not deleted successfully.

• Logical Explanation: The Delete Row in File action takes the value from the Input Value column 3;4;5 and deletes the specified rows (Row 3, Row 4, and Row 5) from the configured Excel file. The execution status of this operation is stored in the {Status} variable as true.