Compare two excel sheets row by row

[THIRU_NANI (NaNi)]

Hi! @vikram,

Yes we can compare 2 dts row by row.

view on this thread

Compare two data tables in different excel files

Hi Guys, i have a two different excel sheets ,here i need to do, first take any row value from excel sheet 1 and search the value which we picked in excel1 in to another excel sheet . if value is there in excel 2, ok no issue …if value is not there we need to through exception. this is the scenario …please any one help me on this.

Regards,
NaNi