Forum Discussion

WillyPete's avatar
WillyPete
Contributor
7 years ago
Solved

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!

WillyPete's avatar
WillyPete
Contributor
7 years ago

It isn't a table variable it is a db variable.  When i try to point a step to the new column in the spreadsheet, the new column isn't listed while all the original columns are. I am not sure i am explaining this correctly. I have attached a screenshot of the spreadsheet and two screenshots of what TestComplete is "seeing". The last column of the spreadsheet, the one i recently added,  is not being shown/seen by TestComplete.

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3
    7 years ago

    Oh, okay, I remembered it wrong from your other question.

     

    Seems to me that the last time I did this, I had to delete the db variable from the project and start over in the wizard.  There wasn't another way to alter the columns.

    • WillyPete's avatar
      WillyPete
      Contributor
      7 years ago

      I deleted the db variable and tried to add it back in, it only sees six columns instead of seven.

      I renamed the db then tried to add it back in, it only sees six columns instead of seven.

      I deleted the entire data loop (copy the contents of the loop then deleting everything and pasting back the contents) then tried to add the data loop back in, it only sees six columns instead of seven.

       

      Hey testcomplete, this should be a feature to be able to do what I am trying, it shouldn't be so convoluted...

      • Marsha_R's avatar
        Marsha_R
        Champion Level 3
        7 years ago

        There's probably a better way to do it but we'll have to wait for tristaanogre or AlexKaras to come in tomorrow and remind me of it.  :)