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 …
Hope this helps you
can you share me the if condition without using for each row part
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
- Read both the excel and store in data tables
- 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
Thanks for the help…
Thanks for sharing …
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.