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!

WillyPete's avatar
WillyPete
Contributor

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
Moderator
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
      Moderator
      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.  :)

      • WillyPete's avatar
        WillyPete
        Contributor
        7 years ago

        Ok, thanks. Hasta Manana...

    • shankar_r's avatar
      shankar_r
      Community Hero
      7 years ago

      Hi,

       

      I just tried the steps you mentioned and all of the scenarios working for me.

       

      What i did:

      1. Created Workbook with one sheet which has 5 columns.
      2. Close the Workbook
      3. In TestComplete, I added DB variable with the created workbook and i see 5 columns
      4. Again, Open the Workbook and added 1 column. Now the workbook has 6 columns
      5. Close the Workbook
      6. In TestComplete, I edited DB variable with the existing workbook and i see 6 columns
      7. Again, Open the Workbook and removed 2 columns. Now the workbook has 4 columns
      8. Close the Workbook
      9. In TestComplete, I edited DB variable with the existing workbook and i see 4 columns

      Have you tried like this? Or i misunderstood your question?

       

      Note: I have tried this workbook scenario in and outside of project folder.

       

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

        WillyPete:

        Hi,

         

        Can you provide a screenshot(s) of how your db variable is defined?
        The case is that this might be not a problem of TC but be caused by the underlying ADO engine or Excel file.

        For example, the problematic last column in Excel may be empty for several initial rows and ADO engine may consider it not to be within data set if the data query looks like "Select * From [Sheet1$]".

        Or you may select from defined data set in Excel file with the newly added column not been added to this data set...