Extract the generated URL from formula in excel

[indrajit.shah (iamvicky)]

how can we extract the generated URL?

[balupad14 (Balamurugan)]

hi @indrajit.shah,

Below it has an activity called "Get Hyperlink ". Using this activity can able to get the hyperlink from excel.

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed new activities called “Insert Hyperlink”, “Get Hyperlink” and “Remove Hyperlink”. Insert Hyperlink - Add hyperlink (display text and address) to the cell . Get Hyperlink - Get the address for the hyperlinked cell. Remove Hyperlink - Remove the hyperlink the the cell (It won’t delete display text) [image] Insert Hyperlink : [image] Get Hyperlink : [image] Remove(Delete) Hyperlink : [image] Note : Special thanks to @Gnaneshwari_Pinna . She gave the idea made …

Regards
Balamurugan.S

[indrajit.shah (iamvicky)]

@balupad14 as i said i tried but I didn’t worked. Can you please see the screenshot i attached one more time and please the forum bar and then the hover url.

[balupad14 (Balamurugan)]

Hi @indrajit.shah,
Can you share the workflow or screen shot please…

Thank you
Balamurugan.S

[indrajit.shah (iamvicky)]

Sure, Please find the attachment New.zip (26.5 KB)

[balupad14 (Balamurugan)]

Hi @indrajit.shah,

I saw your example. It is technically formula. It is not hyper link.

You can use the “Read Cell Formula” activity or you can generate the link inside UiPath.(It is a possible one)…

I have added new column to show you about the get hyper link

Out put.

New.zip (29.9 KB)
Thank you
Balamurugan.S

[indrajit.shah (iamvicky)]

Can you send me the project file you worked for this with the excel file?? coz the url generating is in F cell but you used G cell.

I want the URL generated the same url you get in G cell and how to achieve that?

[balupad14 (Balamurugan)]

I have attached the sample in your above thread…

Thank you
Balamurugan.S

[ssong (SongManho)]

@balupad14
I kept asking you questions,
I didn’t hear any reply.
Please answer me.

https://forum.uipath.com/t/re-uipath-go-balareva-easyexcel-activities/220609

[balupad14 (Balamurugan)]

HI @ssong,

Check this one.

UiPath Go ! BalaReva EasyExcel Activities

Hi @ssong, I have update the new version(19.1.0) in the beginning of the thread . you can download it and use it. I did the change in the Move Sheet activity to move the sheet first and last position. In the Initial Sheet name property you can use below thing with function “:First” - Move sheet in the first position “:Last” - Move sheet in the last position Note : It is case sensitive. Thank you Balamurugan.S

Thank you
Balamurugan.S