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...
Forum Discussion
YMinaev
Staff
StaffHi,
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.
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.