Documentation

GetSheetCount

GetSheetCount command is used to get the count of sheets available in a an excel file.

Select GET_SHEET_COUNT command from the action drop down, leave Screen name blank, Give variable name in the Element key where sheet 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 ${count1}.

Was this page helpful?