Forum Discussion

bklabel1's avatar
bklabel1
Occasional Contributor
4 years ago

Stop Data Source Loop

Sandbox Script     DataSource     SendToConductorWB     DataSource Loop   SendToConductorWB passes values from DataSource to SendToConductorWB.   I'm learning about getting data from one Excel...
  • HimanshuTayal's avatar
    4 years ago

    bklabel1 : If you have 5 rows in your workbook and you have configured your DataSource in a way to execute for each row. So all the step will get executed for 5 times

  • ChrisAdams's avatar
    ChrisAdams
    4 years ago

    Hi Kevin,

    SoapUI does show you a preview of the rows in the spreadsheet in the Datasource window.  If you click the green triangle, and nothing shows, then I'm not sure what is amiss.  Have you defined the columns of interest in the Datasource step that you want to use in your tests?

     

    You're right though, you do have to type in the sheet name.

  • ChrisAdams's avatar
    ChrisAdams
    4 years ago

    Hi,

     

    In the Datasource Step, if you select Excel as the source type, you get three fields below.  These are file name, the sheet to read and the cell in which the test start to read from. 

     

    So, yes, you can see which row the test will start at.