How to read hyperlink text from excel cell

datatable
excel

#1

Hi,

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.

Cheers!


#2

@Daniel_M Can you elaborate more to understand


#3

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