Forum Discussion

CHIMERA's avatar
CHIMERA
Occasional Contributor
9 years ago
Solved

TestComplete returns NULL from Excel in Property Checkpoint, but returns Correct value in Jscript

I am using the Property Checkpoint to verify a value from UI with a value from an Excel. The checkpoint returns a NULL value from the Excel, but when i use a script to do the same, i get the correct ...
excel
Jscript
property checkpoint
returns NULL
TestComplete
  • CHIMERA's avatar
    CHIMERA
    9 years ago

    Resolved!

     

    After reading several articles on TestComplete DDT and Excel compatibility, and even after trying the apostrophe <'> hack, my problem persisted.

     

    Taking info from other articles and the much helpful replies above, that TestComplete determines the format of a Row based on the First Cell of that Row, I Stored a junk value 'X' in all the Empty Cells(which were not required) in my Excel. Now my scripts run smoothly. :smileyvery-happy: 

     

    Thanks for your replies!

leandroaraujoso's avatar
leandroaraujoso
Contributor

Yeah, but that is what I told you in my first post, right?

 

Anyways, glad you solved it!

CHIMERA's avatar
CHIMERA
Occasional Contributor
9 years ago

As ive mentioned, I could understand what you were trying to tell me. But i still hadn't got a solution to my problem.

Thanks for your response. Much appreciate it. :smileyhappy: