Check if value is grater than , using LINQ Query

[Dev2]

Hello Everyone

I have data in excel i want to check if the number in each cell is grater then 1000,

if yes do something else something else.

How I can do that using LINQ query.

Thank you

[Yoichi]

Hi,

Hope the following helps you.

dt.AsEnumerable.Any(Function(r) Double.Parse(r("ColumnName").ToString)>1000)

Regards,

[Dev2]

Thank you @Yoichi , its working but what i am trying to do is , update the cell or coloring cell if the value is grater then 1000

[Dev2]

like this

[Yoichi]

Hi,

Can you try as the following?

arrInt = dt.AsEnumerable.Where(Function(r) Double.Parse(r("ColumnName").ToString)>1000).Select(Function(r) dt.Rows.IndexOf(r)).ToArray

Note: 2 is row offset value of the table.

Sequence.xaml (8.0 KB)

Regards,

[Dev2]

Thank you , Working