How to use Data Driven loop for multiple Excel Sheet?
Hi,
I am using Test Complete to automate a test case.
Test steps are as follows:
1) Open application
2) Select a range[1-10, 1-50, 1-100 etc] from a combo-box.
3) Enter a number in a textbox.
4) Click on Apply button to verify whether input is valid or not.
I have a Excel WorkBook containing numbers to be tested for each range specified in separate WorkSheet. Now, I want to add a Data Driven Loop to fetch these input numbers for selected range from separate sheet.
Here, I can use Data Driven Loop to fetch input numbers from 1 worksheet, but for next range, I can't use next sheet for same Data Driven Loop.
I am using Test Complete to automate a test case.
Test steps are as follows:
1) Open application
2) Select a range[1-10, 1-50, 1-100 etc] from a combo-box.
3) Enter a number in a textbox.
4) Click on Apply button to verify whether input is valid or not.
I have a Excel WorkBook containing numbers to be tested for each range specified in separate WorkSheet. Now, I want to add a Data Driven Loop to fetch these input numbers for selected range from separate sheet.
Here, I can use Data Driven Loop to fetch input numbers from 1 worksheet, but for next range, I can't use next sheet for same Data Driven Loop.
