Documentation

How to get the row count of the number of rows in an excel sheet?

In order to get the count of number of rows in an excel sheet we use GET_ROW_COUNT command from the action dropdown.

Select GET_ROW_COUNT command from the action drop down, leave Screen name blank, Give variable name in the Element key where row count will be stored and provide excel file path in parameter section as shown below:

After completing this step, test step will look as below:

Once count is stored in the variable, it can be accessed via ${rowcount1}.

Was this page helpful?