Forum Discussion

gtourian's avatar
gtourian
New Contributor
8 years ago

Looping the execution of a test, using a different spreadsheet data source each iteration?

We have a need to verify data via the GUI of our application with changed customer data contained in Excel Spreadsheets.  We will get dozens to hundreds of these spreadsheets per month, each from an ...
NisHera's avatar
NisHera
Valued Contributor
8 years ago

It's possible as per tristaanogre $ Marsha_R and it's easier with automation tests rather than manually.

But one other thing you have to be aware,

if the way of entering data defferent from each other (spread sheets) you may have to write test accordingly (and comparatively complex)

 

you may do like 

DDT.ExcelDriver(yourVariable+"\\.xlsx","sheet1",true);
  do
  {
    test code gos here...or just call a test to enter data
     
  }
  while (!(DDT.CurrentDriver.EOF()));
  DDT.CloseDriver(DDT.CurrentDriver.Name);

yourVariable = filepath and name