GetRowCount command is used to get the count of total rows in an excel sheet.

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?