How to read hyperlink text from excel cell


Would anyone know how to extract the actual link from a hyperlink in Excel?
When copying the data to a datatable, only the direct cell text is copied instead of the link itself.


@Daniel_M Can you elaborate more to understand

Hi Indra,

I have an Excel file containing hyperlinks with a different display name as to the actual link itself.
My problem is that I find no way to read the actual links from the cells containing a hyperlink.

Thank you in advance


I had the same problem. It turns out that the formatting of the hyperlink will cause UiPath to read it as “=”. So the solution now for me is that I remove the hyperlink format in the excel sheet such that it is purely plaintext.

Long overdue reply but yeah. Hope it helps.

Here is an activity called “Get Hyperlink” in the below package.