Get Total Row Count

This pre-built action in Avo Assure and located under @Excel element instructs Avo Assure Client to fetch the total count of Rows in the Excel file and save the count 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

The financial application under testing features the capability to upload an Excel file with user details. This function ensures the integrity of user records and verifies that each entry is accurately captured by counting the number of rows in the Excel file. This feature is crucial for validating that the number of rows in the Excel file aligns precisely with the number of processed records. This accuracy is essential for applications in HR management, financial documentation, or inventory management, where each row represents important individual entries.

1. Input Data: N/A In optional case, user gives a column number for specific work.

2. 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.