ContributionsMost RecentMost LikesSolutionsRe: Type Mismatch Error in KeywordTest when Excel sheet column is blankHi, I am sorry, not clear. I used KeywordTest - data driven loop to read values from excel sheet. Pls show me how to use validation code ( aqObject.GetVarType ) here. ThanksRe: Type Mismatch Error in KeywordTest when Excel sheet column is blankI saw one of the post about using aqObject.GetVarType validation before creating my post. The problem is that my form has 50+ fields. 95% of the fields are not mandatory. I have to test both scenario blank and not blank and make sure database stores correct values. If I am not wrong then your recommendation will involve putting 50 verification for 50 columns. That is not efficient. I have to test 20-30 forms like this one. Type Mismatch Error in KeywordTest when Excel sheet column is blankI created a KeywordTest and made a data driven loop with Excel Worksheet in TC8. The purpose of test is to fill customer registration form. The sheet has 5 rows of data with columns like FNAME, LNAME, MID, ADDRESS etc..Now test fails when one of the column is blank and I get "type mismatch" error. How can this be resolved. Re: Updating test step in KeywordTestOk, that worked great. And it resolved my testing case partially. I read through the whole thing and may be I missed something. In my test, instead of phone number I used NAME. I want to run this test 3 times and use row1 Name, then for test2 use row2 Name. So this way I can create 3 customer accounts. Is it possible? Pls see attached.Updating test step in KeywordTest Hello, I recorded one keyword test. Its a customer registration form (C# winform). I added customer name, and other info. My customer form does not duplicate phone number. In order to run test again, I must have automated test to enter a new phone number. How can I update my test step of entering phone number instead of typing in phone number automated step should read number from an excel sheet?