Forum Discussion

marin's avatar
marin
Frequent Contributor
12 years ago

DDT Excel driver will not detect end of file

Hello all, I have a strange problem in my data driven testing project - it seems as if DDT Excel driver can not find the end of file in some cases. I am using following code: ...
  • paul_scroce's avatar
    paul_scroce
    12 years ago
    When I have had a similar problem I would highlight and delete ALL rows below the last row with data that you want in Excel. Usually there are some empty cells with no data but some formatting was applied to them.
marin's avatar
marin
Frequent Contributor
12 years ago
Hello Paul,



many thanks for your reply, much appreciated.



Indeed it  must have been something with formatting of empty cells - I have deleted all cells below last row and now EOF() will be recognized.



Many thanks again,



Marin