Delete Row in File

This is a pre-built action in Avo Assure and comes under @Excel element. The action instructs Avo Assure Client to delete a particular row in the Excel file based on its row number.

Syntax

Input: <RowNumber>;RowNumber>(Optional)

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

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

Use case/Example

Scenario: Eliminating a user record from a financial application

You are testing a feature of a financial application. It verifies that the application allows users to delete a user record correctly. This scenario tests the functionality of the delete row action within the application. It ensures that the application can successfully delete a user record from an application, it deletes the appropriate row without corrupting the remaining data in the file.

Input

5

Expected Result

Row number 5 should be deleted from the excel file.

Output

The output variable {result} contains status of execution as pass, which can be utilized for further work.