For validation in a xlsx file

  • Works for in downloaded file | in Reference file | In file
  • Check the whole file – expected format (filename~sheetname)
    • Iterates through all the rows and then checks if the text to be found matches any of the columns
  • Check a cell – expected format (filename~sheetname~A7)
    • Goes to that specific cell and then checks if the text to be found matches any of the columns

Have other questions? Access our full knowledge base!

Verified by MonsterInsights