Get Total Row Count

This is a pre-built action located under @Excel element, instructs Avo Assure to fetch the count of the total number of rows existing in the Excel file and save the result in the dynamic variable.

Syntax

Input Value: <column number (optional)>

Argument	Description
column number (Optional)	When Input value is not provided: Counts all rows from the Excel sheet. When Column Number is Given: Counts only the rows where the specified column has data.

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

Output Value:

Argument	Description
<Dynamic Variable> (Required)	This variable holds the total numbers of rows
<Dynamic Variable> (Optional)	This dynamic variable holds the results in True or False

Example

Retrieve and Store Total Row Count from an Excel File

The Get Total Row Count action retrieves the number of rows from the set Excel file. If a column number (e.g., 3) is provided in the input value, it counts only the rows where that column has data; otherwise, it counts all rows. The row count is stored in the {Row Count} variable, while the action status is stored in the {Status} variable, with the following possible values:

• True – when the total row count is retrieved successfully.

• False – when an error occurs while fetching the row count.