Regarding Excel Automation in UiPath

0 votes
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.
Dec 12, 2018 in RPA by abhishek
• 120 points
466 views
@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

1 answer to this question.

0 votes

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.

answered Dec 13, 2018 by Shuvodip

Related Questions In RPA

0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16 in RPA by Venkat
• 320 points
2,814 views
0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 9, 2018 in RPA by wrecker
• 3,110 points
1,785 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 25 in RPA by Anvi
• 13,400 points
967 views
0 votes
1 answer

Add filter to excel table in UiPath

If you use *my value as the ...READ MORE

answered May 16, 2018 in RPA by wrecker
• 3,110 points
1,546 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
426 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,065 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
248 views
+1 vote
4 answers

open source tool RPA

Apart from UiPath Community Edition (which is ...READ MORE

answered Feb 25 in RPA by Anvi
• 13,400 points
553 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
343 views
0 votes
1 answer

Pivot table in excel using UIpath

down vo I'd suggest you are going to ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,110 points
892 views