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.” Furthermo…

Hi @harsh2 Take a look on this workflow with your required output. [An Excel spreadsheet contains a table with three columns labeled ID, Name, and PANID, where some cells in the ID column are highlighted in yellow and blue. (Captioned by AI)] Excel Data.zip (63.4 KB) Thanks!!

I need help comparing 2 excel files

Help Studio

sarvesh.b (Sarvesh) January 9, 2025, 6:46am 7

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!!

1 Like

Topic		Replies	Views
Compare two data tables in different excel files Help datatable , excel , activities	21	20530	January 21, 2020
Compare column and update/set color Studio datatable , excel , studio	1	701	December 23, 2020
Compare Two Excel files in Ui path studio X StudioX studiox	3	1992	May 29, 2020
Comparison of two separate excel data (into a datatable may be) in Uipath Help studio	1	933	November 21, 2018
How to compare two excels in uipath? Help activities , studio	12	11018	August 20, 2020

I need help comparing 2 excel files

Related topics