I try to determine if a column in an Excel table contains a specific value.
So far I read the column with “Read Column” which gives me an IEnumerable.
Then I iterate through the IEnumerable and compare each value with the value searched.
This works, but seems a bit slow to me. So I look for a faster and easier to implement way.
Contents of the column can be Integers or Strings, depending on the situation I use it.
I tried IEnumerable.Contains(SearchValue) but always got False as result. Maybe because I provided the search content in a wrong form.