Forum Discussion

alisson_cruz's avatar
alisson_cruz
New Contributor
11 years ago

Excel Data-Driven doubt

Hi, I'm trying to use a .xls file to get values for a test, but there's a point where it doesn't go well. The tests are working fine, they are using values in 2 columns of a excel table....
  • Marsha_R's avatar
    Marsha_R
    11 years ago
    It's not the most elegant solution, but when I had this happen, I copied the specific cells out of my Excel sheet into a new sheet and the new one worked.  



    I never could fix the old sheet.  Best I could figure out was that there was some hidden Excel junk in the extra rows that TC was picking up.  



alisson_cruz's avatar
alisson_cruz
New Contributor
11 years ago
Wonderfull!

It works perfectly.. thank you!



What looks funny now is that with the old XLS, at variable list, there were the columns F2 F3 F4 that should be empty!!

And now it's gone!

  • mgroen2's avatar
    mgroen2
    Super Contributor
    9 years ago

    alisson_cruz Just curious: what is/was the problem? that TC cannot handle empty (or hidden) cells when it's doing DDT?

    • Marsha_R's avatar
      Marsha_R
      Moderator
      9 years ago

      In our experience, TC can handle empty and hidden cells just fine.

       

      The problem seems to be that even though it looks like we have cleared out a cell, there is some invisible-to-the-user Excel formatting saved in it and TC will read it as not-empty and try to process it, thereby causing the test to fail.

       

      We spent many hours trying to fix these sheets when we first encountered the issue and it is much quicker to just cut and paste the wanted data into a new sheet and move on.   Since we only see this when we are first entering the data and not after the test is well established, it isn't much of a concern.

      • joseph_michaud's avatar
        joseph_michaud
        Moderator
        9 years ago

        I think this problem may have something to do with the UsedRange property on the worksheet.  If you've touched a cell and then deleted its contents, the UsedRange is increased to include the cell.  Any application that wants to process the worksheet will probably use the UsedRange to limit the cells it needs to consider.