For each cell

[domingo.ruiz]

Hi @all!

I need to check if there´s an “X” in any of the cells. If there´s at least 1, the condition will be true. How can I check every cell instead of every row?

Thank you in advance

[Aakash_Singh_Rawat]

Hi @domingo.ruiz

Use read range to read excel sheet, assign to var DT.
DT.AsEnumerable.Any(Function(x) x(“yourColumn”).ToString.Equals(“X”)); it will return True or False.

[Anil_G (Anil Gorthi)]

@domingo.ruiz

How

@domingo.ruiz

if you want to check all rows and all column then try this

Dt.AsEnumerable.Any(function(x) x.ItemArray.Any(function(y) y.ToString.Equals("X")))

Cheers

[domingo.ruiz]

@Anil_G

l rows and all column th

Thank you! Will try

[Sudharsan_Ka]

HI @domingo.ruiz

After getting the datatable use Filter datatable and then give the filter condition

FilteredDatatable.Rows.Count>0 should be your condition in the if activity

Regards
Sudharsan

[domingo.ruiz]

Thank you all! Solved!