Why Excel is not showing HyperLink When Copying an Address on it?

Help Studio
, , ,
1

Dears,

Why Excel is not showing HyperLink ( highlighted in blue and underligned) When Copying Links from Web Pages ?

Example :

image
image938Ă—92 4.6 KB

Thanks in Advance

2

@hsendel

Is it BOT copying data from Web application to Excel file or manually you are copying it ?

1 Like
3

Hi @lakshman , YES the BOT copying Address from Navigator and insert it in Excel, and the link will be visible and clickable only after double clicking on related cell and becomes blue and undelined ( Default Link format).

4

@hsendel

Try below way to convert it to Hyperlink.

           =HYPERLINK(Cell Address)
1 Like
5

Thanks a lot @lakshman , we’re always learning new things with UiPath Community.
I got the idea but how to implement the same in using write range instead of write cell ? Probably need some sort of index to be added for each cell to be writen, No? or Need to declare this HYPERLINK as variable?

image
image379Ă—128 9.7 KB

Thanks in advance

→ EDIT : Problem Solved by Using “Write Range” inside Excel Application Scope . Thanks a lot for your support :+1:

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.