Forum Discussion

Azeddin_Margani's avatar
Azeddin_Margani
Contributor
10 years ago

Data-Driven - To read next row of excel sheet.

Hi,   I have a scripts which reads data from excel sheet (It contains 3 rows of 1 column). When executed, it completes successfully for the first row but it doesn't continue to the second then thir...
NisHera's avatar
NisHera
Valued Contributor
10 years ago

Best way is to use Xl diver comes with TestCompleate as follows

 

DDT.ExcelDriver("C:\\YourData.xlsx","Sheet01",true);
do
{
         YourVariable = DDT.CurrentDriver.Value('Column01');
       //do something with YourVariable
        DDT.CurrentDriver.Next();
}
while (!(DDT.CurrentDriver.EOF()));
DDT.CloseDriver(DDT.CurrentDriver.Name);