Forum Discussion

CHIMERA's avatar
Occasional Contributor
10 years ago

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 ...
  • CHIMERA's avatar
    10 years ago



    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!