Find value in other datatable

Help
1

Hi all,

I’m looking for a best practice for the following.
I have an excel file and a web page. If the item on the webpage does not exist in the excel (second column), then it should append it as a new row in the excel.

Excel file:
image

Webpage:
image

I started by storing the excel as a datatable, then using data scraping to get the datatable out of the web page and now I’m looking for a way to identify to add the new ones in the excel file as last rows.

Thanks

2

Solved in the meantime with the following code:

yourdt.AsEnumerable().Any(Function(x) x(“Column”).ToString = DesiredValue.ToString)