Get Total Row Count
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
Input Value: <column number (optional)>
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:
<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.