Comparing datatable with excel data

Help Automation Hub
,
1

Hello

Need help with below,

I should data from website - used ExtractDataTable activity
I have excel data as below screenshot

A spreadsheet with the header "Add, Create Change" listed under the column titled "Headers." (Captioned by AI)
A spreadsheet with the header "Add, Create Change" listed under the column titled "Headers." (Captioned by AI)289×347 4.62 KB

I have read the excel (Included add headers) and stored as dt_exceldata variable.

I have converted these 2 datatables as list with list_excel and list_web as variable names.

Now, I should compare list_web with list_excel, if it matches print and click on the element on web based on user input and if it doesn’t match print the missing values

2

Create a new list to store the difference only using below expression

Final_list = list1.Except(list2)

If the final list count is 0 - both the list are matching. Else print the missing values using the loop function

3

Yeah I stored the same way

MisingColumn=ExcelColumns.Except(WebColumns).ToList()

Still unable to extract

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

5

Pls try below one:
MissingColumns = ExcelColumns.Where(Function(col) Not WebColumns.Contains(col)).ToList()