Service Virtualization

How to read specific rows from the excel and compare with the existing excel?

  • 1.  How to read specific rows from the excel and compare with the existing excel?

    Posted Apr 25, 2018 08:34 AM

    How to read specific rows from the excel and compare with the existing excel?


    Hi, As per my scenario, I used "Read rows from excel" data set.

     

    In sheet1 having 500 rows , for scenario1 I want to call from row number 1 to row number 20, again for scenario2 I want to call from row number 21 to row number 40 and so on. and we want to compare these rows with the JDBC result set or existing excel.

     

    Actual issue is for scenario1 , its correctly reading from row number 1 to row number 20, when it goes to scenario2 its not reading from row number 21 to row number 40 instead again its reading from row number 1 to row number 20

     

    please suggest.