change a specific column of an excel sheet in UiPath

0 votes
I have an excel sheet that has a data like this

Position        URL       Company  Location
Manager  /xyz/123/xyz    AAC      UK
Tester /xyz/132/asd    BBD       UK
architect /xyz/142/asf    CDD       UK

I want to get the urls and add www.xyz.com/ before each of them and remove old url and place new url. my sheet should look like this

Position        URL                  Company  Location
Manager   www.xyz.com//xyz/123/xyz    AAC       UK
Tester  www.xyz.com//xyz/132/asd    BBD       UK
architect  www.xyz.com//xyz/142/asf    CDD       UK
I have made the workflow but dont know how to replace the url

pls help
Apr 19, 2018 in RPA by Sahiti
• 6,370 points
5,851 views

2 answers to this question.

0 votes

You can use a For each row loop to iterate through the data table

replace the value in the url col using Assign activity.

Use Excel application activity and have write range. enter the table inside it

thanks

Gain expertise in robot process automation (RPA) tools and concepts by obtaining RPA Certifications.

answered Apr 19, 2018 by wrecker
• 3,110 points
+1 vote

1. First of all , you need to read your input excel using read range activity inside Excel application scope.(you will get the datatable from here)

2. Now use for each row activity to iterate through each row of the datatable .

3.use below logic: 

for each row of Data table

{

string = Row(1).tostring

excel application scope[

write cell activity in the range section use the "B"+(count+2).tostring

in value section =  "www.xyz.com\string"

]

count++

}

4. Write range will give you the output as you expected.

answered May 16, 2019 by Venkat
• 320 points

Related Questions In RPA

0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 22, 2018 in RPA by ffdfd
• 5,550 points
1,115 views
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,140 points
4,512 views
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12, 2019 in RPA by anonymous
• 120 points
2,283 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
1,853 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
1,588 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
2,684 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
1,825 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
14,734 views
+2 votes
3 answers

UIPATH print a list

1. create a list using listName= new ...READ MORE

answered May 16, 2019 in RPA by Venkat
• 320 points
10,708 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP