Forum Discussion

WillyPete's avatar
WillyPete
Contributor
7 years ago

Want to add a new column in excel for a data driven loop

I have a data driven loop that is pulling from an excel spreadsheet.  Four of the six columns are for products the company offers and the company has added a fifth product, so i wanted to add a new c...
  • WillyPete's avatar
    WillyPete
    7 years ago

    So, after spending last night thinking about the problem, Shankar's first response got me thinking and I gave the project to a colleague to try on his computer to see if it was just my setup, since what I wanted to happen was working like I expected for Shankar.  My co worker opened the project, edited sheet 1 of the spreadsheet and it worked for him the way it did for Shankar.  I then took his copy of the project and put it on a laptop we lend to contractors and it didn't work there.  Then I realized the problem, my co worker edited sheet 1!  When i was opening the spreadsheet it was defaulting to sheet 4 which is the master list of all available countrys, not the working list for the current execution...  So it was something embarrassingly simple that was the problem, user error.  I had been editing sheet 4 in excel and in test complete I was looking at sheet 1! 

    Thank you for the help everyone!

AlexKaras's avatar
AlexKaras
Champion Level 3

Hi,

 

> I have attached a series of screenshots that show how I defined the db variable.

No, I was talking about screenshot(s) of the wizard from TestComplete when you defined the db variable (sheet name, query, etc.).

WillyPete's avatar
WillyPete
Contributor
7 years ago

So, after spending last night thinking about the problem, Shankar's first response got me thinking and I gave the project to a colleague to try on his computer to see if it was just my setup, since what I wanted to happen was working like I expected for Shankar.  My co worker opened the project, edited sheet 1 of the spreadsheet and it worked for him the way it did for Shankar.  I then took his copy of the project and put it on a laptop we lend to contractors and it didn't work there.  Then I realized the problem, my co worker edited sheet 1!  When i was opening the spreadsheet it was defaulting to sheet 4 which is the master list of all available countrys, not the working list for the current execution...  So it was something embarrassingly simple that was the problem, user error.  I had been editing sheet 4 in excel and in test complete I was looking at sheet 1! 

Thank you for the help everyone!