I need help comparing 2 excel files

[harsh2]

I have two Excel files, each consisting of ten columns with similar headers and a considerable number of rows. I wish to compare the values in column “A” of both files. If the second file has matching values in column “A” with the first file, I would like those cells to be colored “Green.” Furthermore, if the second file contains any new values in column “A,” I would like to change the color of those cells to “Blue.” All modifications will be made to the second file. What is the most efficient way to proceed with this?

Thanks,

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @harsh2,

Please refer below threads:

How to compare two excels in uipath?

See attached workflow, ExcelSheet2 would have the result once you run it - Main.xaml (17.9 KB) ExcelSheet1.xlsx (8.5 KB) ExcelSheet2.xlsx (8.5 KB)

Comparing two separate Excel files and keeping only unique results

I guess that might happen if there are no unique values from the 2 datatables. Basically, the 2 datatables are identical. I made some changes to the initial workflow in order to handle this. UnqValuesFrom2Dt_v2.xaml (13.7 KB)

Comparing two Excel Sheets in UiPath (Tutorial from Start to Finish)

Please note: You might have to do few tweaks to get the color coding, but following these threads, you should be able to develop a solution to do the comparison.

Regards
Sonali

[harsh2]

I already checked this but it didn’t help moreover I need help with color as well.

Thanks,

[bhanusai_sajja]

@harsh2,

Did you try using two for each activities.

[yedukondaluaregala]

Hi @harsh2 ,

you can below steps to get the solution,

1.Find the Matched data from two excels and prepare one new datatable.
2.loop output datatable, and whatever the items you get check those names with 2 excel data, check whatever the matched items and apply the color for remaining you can set another color based on your requirement

[singh_sumit (Sumit Singh Tariyal)]

Hey @harsh2 for this logic use 2 read range and save their output in dt1 and dt2 now use two for each row and inside for each use one if condition and inside if pass if currentrow1 = currentrow2 → in then branch use set color range or for comparing you can this logic also for this logic you dont need two for each.

dt1.AsEnumerable().Where(Function(r)r(2).ToString().Trim=CurrentRow(2).ToString().Trim)

[sarvesh.b (Sarvesh)]

Hi @harsh2

Please find the zip folder contains 2 excel dummy files. matching the data in A column from both the excels and adding colour in excel2 file for the data matching in excel1 file.

Excel Data.zip (48.7 KB)

Thanks!!

[harsh2]

Hi, Sorry for the confusion I wanted to to something like this :

File1 :

File 2 :

Result :

[sarvesh.b (Sarvesh)]

Hi @harsh2

Take a look on this workflow with your required output.

Excel Data.zip (63.4 KB)

Thanks!!

[harsh2]

Thank you @sarvesh.b ! I appreciate the help.