i am making a robot that reads off an excel sheet and notifies the user if there is a value of 0 using a messafe box/ input dialog. how do i do this?
example.xlsx (10.0 KB)
an example of the excel sheet is attactched
With your data table in hands, test it with an If Activity.
myDataTable.AsEnumerable.Any(Function(row) row("Number").ToString = "0")