Ask a Question

Type Mismatch

Frequent Contributor

Type Mismatch



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.

Champion Level 2

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.

Valued Contributor

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

Frequent Contributor

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

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

Showing results for 
Search instead for 
Did you mean: