For each cell

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

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.


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")))


Thank you! Will try

1 Like

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


Thank you all! Solved!

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