change a specific column of an excel sheet in UiPath

Question

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

Answer 1

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.

Answer 2

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.