Compare collection value with excel column value

Off-Topic Discussions
1

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

2

@amit.chaudhary,

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)
{
true
}
}
}

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,
@hacky

2 Likes
3

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