How to match the value in between two excel

Hello guys,

I have a question.

I am attaching two excel files .

Demo-1.xlsx (8.4 KB)
Demo-2.xlsx (8.3 KB)

Both file have “Kohli” under “Name” column .

How can I match these two value using Uipath??

Thanks & Regards

Hi @nirmalya.sarkar,

what do you mean by match here?
Do you want to check that the name Kohli belongs in the Demo2 excel or not? or someother thing.


@Shikhar_Tandon ,

I want to check whether name kohli belongs in Demo1 or not.


Try this:

yourDT.AsEnumerable().Any(Function(x) x("Column1").ToString = DesiredValue)
It will return True if any of the rows match the predicate.


Hi @nirmalya.sarkar

if you need dynamic for a changing value in dt1

Refer to the xaml below!

Main.xaml (7.8 KB)
project.json (1.5 KB)


find starter help here:
Find_Common_NonCommon_By1Col.xaml (12.3 KB)

@pravin_calvin ,

Can you store the value in a variable as “Kohli” . It is my actual requirement.

Thanks & Regards