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

cunderw's avatar
cunderw
Community Hero
9 years ago

In my experience, the DDT driver tries to determine the cel value type by the first 10 rows in the sheet and what most of them are. Try putting 10 rows before your actual data (after the header) and put Xs in all of them.