Comparing datatable with excel data

Help Automation Hub
,
4

No need to change into list below LINQ will give you the matching output

dt1.Select.Where(Function(x) dt2.AsEnumerable().Any(Function(y) x.Item(“ColumnName”).ToString.Equals(y.Item(“ColumnName”).ToString))).CopyToDataTable