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...
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
