Compare Two Excel Files and Delete Matching Rows in one excel file

[Manisha_Ravindra]

Check this linq:

dt_ExcelB = dt_ExcelB.AsEnumerable().Where(Function(row) Not dt_ExcelA.AsEnumerable().
Select(Function(a) a(“Your Value”).ToString.Trim).Contains(row(“Invoice Number”).ToString.Trim)).CopyToDataTable()