Compare two excel sheets row by row

[vikram]

Can anyone please suggest how can we compare two datatables row by row and highlight differences in 1st excel sheets

[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

[kadiravan_kalidoss (Kadiravan K)]

Hi @vikram,

Please provide sample input data and expected output in excel sheet. That will help us to give exact solution.

Thanks!

[vikram]

Uploading: Excel1.xlsx…
Excel1.xlsx (16.6 KB)
Excel2.xlsx (16.6 KB)

Excel 1 and Excel 2 , need to compare these two files and highlight records in Excel 1

[Charbel1 (Charbel)]

Hey,

Check this out:

Excel highlight compare.xaml (9.4 KB)

Best,
Charbel