This is a Powershell cool excel automation which validates a values using regex whther they are matching the required pattern or not ,by entering the status coloumn in same excel file
#It imports the excel #Then it takes one of the property value to go for valifdation on the particular column(here it takes state attribute to validate passcode attribute) #if it matches will add a status property as ok or not ok #maily switch cases are used