Forum Discussion

romanmfs's avatar
romanmfs
Frequent Contributor
7 years ago
Solved

Type Mismatch

Hi!

 

I have a simple datadriven test case that opens up a page and fills in values to the fields. 

Excel doc has 3 different values for each column (eg: eamil, name etc).

 

The test runs fine but when it reaches the end of the loop for some reason it tries to go 4th time (or if I delete the rows and only will have 1 row, TC will try to open the page the 2nd time) and then failes with 'type mismatch".

 

Any ideas? Screenshots attched.

  • Excel thinks that the next row has data in it even if you don't see any.  I've seen some threads in the forum on how to get around this but the quickest solution I found was just to copy my data to a new sheet, being very careful not to get extra rows in there.

4 Replies

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3

    Excel thinks that the next row has data in it even if you don't see any.  I've seen some threads in the forum on how to get around this but the quickest solution I found was just to copy my data to a new sheet, being very careful not to get extra rows in there.

  • karkadil's avatar
    karkadil
    Valued Contributor

    If Marsha's answer doesn't help, please attach your excel file here

  • romanmfs's avatar
    romanmfs
    Frequent Contributor

    This is very annoying, now it happens even if I start from fresh sheet!..

    • Marsha_R's avatar
      Marsha_R
      Champion Level 3

      Okay, then, like karkadil said, please attach your Excel file here and we will help you analyze it.