Forum Discussion

Dom's avatar
Dom
New Contributor
10 years ago

TestComplete data driven loops not working for second row of an xls file

Hi

 

Does anyone know of any simple misktakes that could stop a data-driven loop from and xls file stop working for a web page?

 

My data loop successfully takes the data from the first row of a spreadsheet (to set up new users in a web app), but fails to find the data in the second row.

 

When watching the script on the second iteration I can see that TestComplete goes to the correct field to enter the new username, but nothing happens ans it continues without erroring. 

 

Alternatively, does anyone know whoe to debug a data-driven loop to see if I can understand what is happening in the background.

 

Many thanks,

 

 

Dom.

data-driven loop
debug
Debugging
excel
loop
xls
  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    10 years ago

    Is this using the built in DDT Excel driver? Or loading Excel via COM and using it yourself through script?

    • Dom's avatar
      Dom
      New Contributor
      10 years ago

      Hi

       

      Yes, just the standard DDT Excel driver.

       

      I'm just using the standard right-click -> "insert data driven loop" in the keyword test interface. No scripts, COM commands or anything fancy.

       

      Cheers,

       

       

      Dom.

      • Colin_McCrae's avatar
        Colin_McCrae
        Community Hero
        10 years ago

        Ah OK. Thats me out then I'm afraid.

         

        I use Excel via COM. No experience of the built in data driver ....