Forum Discussion

vie_huynh's avatar
vie_huynh
Occasional Contributor
13 years ago

Question regarding data driven test for TC

So I break down small tests and organize them into a big test. Then I want to make an excel data sheet for data driven test. There would be multiple sheets for each small tests. Then come the question for the rows. I understand that each column represent different categories that could be selected in that tested app, but do the rows need to be exactly the same for every sheet in that particular test? And how TC run through the test? Is it running like first record of every sheet that is selected, and when it done for the first one, it goes for the second record, aka the second row?
  • YMinaev's avatar
    YMinaev
    Icon for Staff rankStaff
    13 years ago
    Hi,



    DDT reads values from a sheet row by row. Each loop iteration imports data from the specified columns of a single row. Then it moves to the next row and so on until there're no more rows in your sheet.



    As for reading data from different sheets, you should create an individual loop for each of them. DDT doesn't iterate through sheets itself, it uses only the one you specify. Since sheets are independent, each of them can have any number of rows.