How to check if excel contains specific text

Help Studio
, , , , , , , , ,
1

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

image
image949Ă—693 112 KB

2

thanks for any idea guys

3

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

2 Likes
4

legendary answer

5

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