Forum Discussion

Dom's avatar
Dom
New Contributor
9 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

4 Replies

Sort By
  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    9 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
      9 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
        9 years ago

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

         

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