Compare collection value with excel column value

I have a collection of type List(of String), i need to check if List value present in one excel column(email_id)


As per my understanding, you need to compare each value of the collection list with each value of the excel column “email_id”.

Considering the above condition, I will try to help you.

You can run a nested for loop as shown below:-

for each item in ListCollectionArray
for each row in dtDataTableOfExcel
if (item.tostring.trim.equals(row(“email_id”)).tostring.trim)

Please note that above logic was created to give you idea. You might need to twerk the code.

Please let me know if you have issues in understanding my approach. ]

Thanks and Regards,


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.