Forum Discussion

Urmikhan's avatar
Urmikhan
Occasional Contributor
5 years ago
Solved

Data Driven Testing using Excel file and import in to my script multiple times

Using DDT Driver for test data excel sheet to my script but it is not working .Could you give me the syntax how I iterate multiple test data in to my scripts: I am using this syntax: function Tes...
  • LinoTadros's avatar
    LinoTadros
    5 years ago

    This is all you need to reiterate through all the records in the excel worksheet:

    function Test()
{
  DDT.ExcelDriver("File path and name", "Sheet name");
  While (!DDT.CurrentDriver.EOF())
  {
    Log.Message(DDT.CurrentDriver.Value("CustomerName"));
    DDT.CurrentDriver.Next();
  }
}

    Thanks

    -Lino

LinoTadros's avatar
LinoTadros
Community Hero
5 years ago

This is all you need to reiterate through all the records in the excel worksheet:

function Test()
{
  DDT.ExcelDriver("File path and name", "Sheet name");
  While (!DDT.CurrentDriver.EOF())
  {
    Log.Message(DDT.CurrentDriver.Value("CustomerName"));
    DDT.CurrentDriver.Next();
  }
}

Thanks

-Lino