Search In Excel Data Table using linq

@dutta.marina

Why not use a filter datatable to check if match is found instead of for each

Another way if you want for eqch is use a boolean variable…set to true if found…on not found side do nothing…also you can use break on the true side sao that remaing rows neednot be checked

And after loop check if values is true then dont add else add or viceversa based on what you need

Cheers