TestComplete returns NULL from Excel in Property Checkpoint, but returns Correct value in Jscript
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!