How to check if excel contains specific text

how do we check a row in sheet using read range , I wanted to check if sheet contains failed status , if sheet contains 1 failed status return true. Any idea guys thanks/>

thanks for any idea guys

yourDataTableVar.AsEnumerable.Any(Function (x) x(“Status”).toString.toUpper.Contains(“FAILED”))

if there is 1 or more rows where Status col value is failed, the statement retunrs true

1 Like

legendary answer

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.