Regarding Excel Automation in UiPath

Question

If I have two columns in two different excel sheets with same column names
like Sheet 1:- Sr.No and Salary
Sheet 2:-Sr.No and Salary
I have to add third column in sheet 2 as “Status”

i want to mach the salary of sheet 1 and Sheet 2, if it is equal then i have to set the Status column of sheet 2 as Matched else Unmatched.

sheet one is standard one while data in sheet 2 is scrapped data from application.

Comments

@abhishek what you are trying to do can be done in simpler ways using excel itself

(=Sheet1!CellNumber operation Sheet2!CellNumber )

This way you can do this.

Hope its helps and simplifies task

Answer 1

You can do it in excel itself.

Sheet 1

Sheet 2 

Sheet 3 where you want to check the equality fucntion or any other operation you want to do.

Hope this helps.