Creating Hyperlink of file path in excel

Help
,
1

Capture

I’ve successfully got the files path and appended the value in excel column. Now I want those files path as hyperlink in new excel column “URL”. Can anyone help me out?

1 Like
2

you can automate the excel by reading the value and iterate through it.

change the value of Text to display using the File Path value in your excel and the Type the cell reference using the counter to increment the value to where do you want to put the File Path value. @nibir08

image
image930×226 16.2 KB

1 Like
3

sorry i didn’t get the part “counter to increment”. Can it be done using uipath?

1 Like
4

You need to put the counter for you to increment the value in the Type the cell reference.

For example:

Your first iteration the value of counter is 1 so the value of Type the cell reference is A+counter.ToString

the next iteration is counter is 2 so the value of Type the cell reference is A+counter.ToString

@nibir08

cheers :smiley:

Happy learning :smiley:

1 Like
5

new
new457×528 12.7 KB

this is my file saving workflow. Actually I’m not sure how to do the “URl” part. It would be really helpful if I get a demo.

1 Like
6

like what i said you need to automate the excel.
1.Click the hyper link in the excel.

image
image852×587 60.9 KB

2.Click the Place in this document.

image
image995×571 74.2 KB

  1. Put the value in the highlighted area

image
image697×372 14.7 KB

Then repeat step 1 to 3

cheers:D

Happy learning:D

2 Likes
7

The is having an activity called “Insert Hyperlink”. The single activity inserts the hyperlink to the cell inside excel.

Regards
Balamurugan.S