So, another Excel automation won the voting at LinkedIn. So, here it is: This time I will show you how you can implement some nice data validation of data from Excel table. I will do this video based on our RPA Challenge ✓ RPA Challenge 26 - Structured Data Validation - #8 by roman.hruska . You will see how to validate if some column contains date in proper format, or if it contains exactly one from two options and also if it contains exact amount of characters.
Download source code
22_Solution.zip (64.0 KB)