Check value in another excel

Hi,
I have two excel.
in first excel i have id–id1
and in the second excel which is the master excel id–id2 value in excel.
-need to check the whether id1 is available in id2 or not
can anyone help me …

1 Like

@vaishaliR

Check below post
Tutorial : How to check a string is present in Excel Sheet || Part - 1
Tutorial : Check value exists in Excel Sheet using UiPath (Part-3) | Without using ForEach Loop/FilterDatatable

Hope this helps you

Thanks

1 Like

hey @vaishaliR

this video will solver your doubt: https://youtu.be/_SHU8uTVvaE

1 Like

can you share me the if condition without using for each row part

1 Like

@vaishaliR

DT.AsEnumerable().Any(Function(x) x("ColumnName").ToString.ToUpper = Your Value)

If you are using this then you have to add the assembly reference, which i explained how to do

Mark as solution if this helps

Thanks

1 Like

@vaishaliR

  1. Read both the excel and store in data tables
  2. Loop through the data table within the other data table and if condition as

row1(“column name”).tostring.Contains(row2(“column name”).tostring)

Hope this will help you

Best Regards,
Vrushali

1 Like

Hi,
Thanks for the help…

1 Like

Thanks for sharing …

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