Forum Discussion

S_Leonardo's avatar
S_Leonardo
Occasional Contributor
9 years ago

DDT object not reading excel values properly

Hi all,   I have several scripts that read data from excel sheets using DDT objects and i'm having problem with one of them.   I can't explain the problem using just words so i made a little scri...
  • Marsha_R's avatar
    9 years ago

    We are giving you workarounds and I would hope someone has a real answer but at least these things work.

     

    My experience has been that we can't leave data cells blank and test for that.  We ended up putting a period in the "no data" cells and testing for a period rather than a blank.  

     

    It's not elegant but it works and we didn't have time to stop and figure out something pretty.  :)