cancel
Showing results for 
Search instead for 
Did you mean: 

Type Mismatch Error solution?

SOLVED
David_D
Senior Member

Type Mismatch Error solution?

Data-Driven test using Excel as a data source.

 

Test Case: Updating a street address.

 

Street Address 1 is required. 

Street Address 2 is optional.

 

Implementation:

A Keyword Test accesses an Excel sheet and passes the cell values as parameters to keyword tests (UpdateStreetAddress1 and UpdateStreetAddress2).

 

Since Street Address 2 is optional, my first attempt was to leave Street Address 2 empty in the Excel sheet.  This triggers a Type Mismatch when UpdateStreetAddress2 is called as it is expecting a String.

 

My solution:

 

The calling Keyword Test would use aqConvert.VartoStr to essentially “type” the value when calling UpdateStreetAddress2.  This works and it would allow me to use aqConvert.VartoInt and/or aqConvert.VartoFloat as appropriate for other datatypes.

 

This seems to me the most straightforward approach, but I'm still learning test complete and perhaps there is a better solution.

 

Comments?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Marsha_R
Community Hero

Re: Type Mismatch Error solution?

Welcome to Problems with Excel  😄

 

If that solution works for you, then go for it.   I've also done things like put a special character in the cells that are meant to be empty so I can check for that character.

 

Eventually I got tired of the work arounds and switched to using .csv files wherever I could.  I can always view them in Excel if I need to, but my testing copy is .csv

View solution in original post

1 REPLY 1
Marsha_R
Community Hero

Re: Type Mismatch Error solution?

Welcome to Problems with Excel  😄

 

If that solution works for you, then go for it.   I've also done things like put a special character in the cells that are meant to be empty so I can check for that character.

 

Eventually I got tired of the work arounds and switched to using .csv files wherever I could.  I can always view them in Excel if I need to, but my testing copy is .csv

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors