Forum Discussion

Sherry's avatar
Sherry
12 years ago
Solved

help! how to get total row count in Excel File datasource?

hi, I need some help here, I need to get the total row count in a Excel File which is used as DataSource. Does anyone know hot to do that? Thanks, Sherry
  • georgetjose's avatar
    georgetjose
    5 years ago

    To get the total number of rows in the Excel.

    def rowCount = testRunner.testCase.getTestStepByName('DataSource').rowCount;

    or

    def rowCount =testRunner.testCase.testSteps["DataSource"].rowCount;

     

    Note: Assuming that DataSource is the name of the Step.

     

georgetjose's avatar
georgetjose
Occasional Visitor

To get the total number of rows in the Excel.

def rowCount = testRunner.testCase.getTestStepByName('DataSource').rowCount;

or

def rowCount =testRunner.testCase.testSteps["DataSource"].rowCount;

 

Note: Assuming that DataSource is the name of the Step.

 

Olga_T's avatar
Olga_T
SmartBear Alumni (Retired)
5 years ago

Hi all,

 

Thanks for the reply, georgetjose !

 

Sherry, is this what you were looking for?