Explore Courses Blog Tutorials Interview Questions
+1 vote
in RPA by (12.7k points)
I have an excel sheet that has a data like this

Position        URL       Company  Location

Developer  /xyz/123/xyz    ABC       US

Manager    /xyz/132/asd    ASD       US

Tester     /xyz/142/asf    ABD       US

I wish to capture all the url from this sheet and add "" before them and replace the old url with the new url so that the sheet becomes like this

Position        URL                  Company  Location

Developer    ABC       US

Manager    ASD       US

Tester    ABD       US

The work flow that i have till now is 1) Open excel application scope 2) Use read range 3) Use for each row to fetch the url 4) Use assign activity to create a new variable and save the new url in it

But i am not able to understand how to replace it

Would appreciate any help

1 Answer

+1 vote
by (29.5k points)
edited by

a For each row you can loop through the datatable and replace the value in column URL using an Assign activity like this:


Want to learn UIpath from scratch! Have a look at this video on UIpath provided by Intellipaat:

Next, use Excel application scope again. Look for the activity Write range (System > File > Workbook > Write range) and enter the datatable. I recommend you to check Add headers.


This will add the datatable to the Excel file selected.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 4, 2019 in RPA by Abhishek_31 (12.7k points)
0 votes
1 answer
asked Jul 10, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer

Browse Categories