Forum Discussion

abhibajare's avatar
abhibajare
New Contributor
14 years ago

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 ...
YMinaev's avatar
YMinaev
Icon for Staff rankStaff
14 years ago
Hi,



In this case, keep all your test data in a single sheet because DDT drivers and loops work with a single sheet. As an alternative, read your Excel files via COM which allows you to access data in them from any sheet at any moment of time, but this will require writting a script function. For example.