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
225 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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 260 points
1,492 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,090 points
1,041 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
• 5,960 points
547 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,090 points
930 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,090 points
237 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,090 points
776 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
123 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
• 5,960 points
360 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,090 points
190 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,090 points
459 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.