How to read data from two different excel sheets and compare each cell

[yadish_s]

Hi,

I have two different excel sheets and i need to compare each cell from sheet A and sheet B if cell A1 in sheet A is equal to cell A1 in sheet B i need to update a new excel sheet cell A1 as true if its false then i have to update it as false. Please help me to resolve this.

[vignesh.ks]

Hi @yadish_s

Welcome again to UiPath Forum.

Please find the below screen shot. Try this method and let me know whether it meets your expectation.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

[yadish_s]

Hi @vignesh.ks

Thank you for providing the solution.

I tried the same method as per the screen shot but my result sheet has multiple output.
Please find the below screenshot for reference.

sheet1

sheet 2

Result

[vignesh.ks]

Give break activity and try it. I attached screen shot for your reference.

Thanks

[yadish_s]

Thanks a lot this is working fine now.

Could you please let me know how to implement the same logic for multiple columns

[vignesh.ks]

@yadish_s

Could you please let me know how to implement the same logic for multiple columns

Hi @yadish_s

Could you please elaborate more on this. Thanks.

[yadish_s]

I have column A, column b & column c of sheet1 i need to compare this with column A, column b & column c of sheet2 and print true or false in each cell in new excel

[vignesh.ks]

you can build logic like below.

row1(“yourColumnName”).ToString.Equals(row2(“yourColumnName”).ToString) and row1(“yourColumnName”).ToString.Equals(row2(“yourColumnName”).ToString) and
row1(“yourColumnName”).ToString.Equals(row2(“yourColumnName”).ToString)

Use And operator in if activity, it will validate all the given columns.

Thanks.

[yadish_s]

Hi @vignesh.ks

The data is been printed only in Column A where as i need the data to be printed in all columns. Please find the below screen shot as sample output.

Thank You

[vignesh.ks]

@yadish_s

I have column A, column b & column c of sheet1 i need to compare this with column A, column b & column c of sheet2 and print true or false in each cell in new excel

Hi @yadish_s

I have one doubt here. Do you need to validate each column separately and write true or false.

Or do you want to validate all the column values at once and write true or false.

Please confirm. Thanks.

[yadish_s]

Hi @vignesh.ks

I have two input sheets.

Sheet A

Sheet B

i need to compare these two sheet column by column separately and print the result as true or false in each cell of every column in result sheet. I have placed a sample result sheet below.

Sample result sheet

Thank you

[vignesh.ks]

Okay, Make build data table has 3 columns, like below:

And then, the workflow should be like this:

Give array row into add data row activity like this:

Thanks.