Get Total Row Count

This is a pre-built action in Avo Assure and comes under @Excel element. This action instructs Avo Assure Client to fetch the count of the total number of Rows existing in the Excel file and save the result in the output variable.

Syntax

Input: column number (optional)

Note: It is essential When the user needs row count of Particular column.

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

Use case/Example

Scenario: Validating the Number of User Records from an Excel File

You are testing a financial application that allows users to upload an Excel file containing user details. It ensures that all user records have been written correctly, this action is used to count the number of rows in the Excel file. It allows testers to validate that the number of rows in the Excel file corresponds accurately with the number of records processed by the application. This is particularly useful in scenarios where data accuracy is critical, such as HR management, financial records, or inventory tracking, where each row represents important individual entries.

Input

• N/A

• In optional case, user gives a column number for specific work.

Expected Result

• The variable {Result} holds the number of rows present in the User details sheet of the Excel file.

• It should be Store the Total row count in a variable {Result}.

Output

The output variable {Result} contains the total count of rows in the excel sheet.