topic RE: Extract hyperlink from excel cell in Product Forum

Extract hyperlink from excel cell

RohiniPatil — Wed, 29 Sep 2021 14:36:00 GMT

Hi,

I have excel file which contains some hyperlinks. I want read that hyperlink. how can i get it?

------------------------------
Rohini Patil
------------------------------

RE: Extract hyperlink from excel cell

VedSengupta — Thu, 30 Sep 2021 10:59:00 GMT

Hello Rohini,
If the cell where the hyperlink is embedded is static you can ready that cell value as text and store in data item and try using that as an input to launch your hyperlink.

------------------------------
------------------------------
Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore | INDIA
*If you find this post helpful mark it as best answer*
------------------------------
------------------------------

RE: Extract hyperlink from excel cell

RohiniPatil — Thu, 30 Sep 2021 12:42:00 GMT

No, i try that but i was getting name of that hyperlink e.g if its display ABC as link then output was ABC not the hyperlink.

Thank you. we have resolved it by writing code stage to get URL

------------------------------
Rohini Patil
------------------------------

RE: Extract hyperlink from excel cell

Moses19 — Wed, 17 Jan 2024 07:19:00 GMT

Hi @RohiniPatil1,

Can you please share the code you had to write to get the links?
Thank You.

------------------------------
Moses Kobe
Developer
Discovery Limited
Johannesburg
0824899205
------------------------------

RE: Extract hyperlink from excel cell

Mukeshh_k — Thu, 18 Jan 2024 09:46:00 GMT

Hi @Moses Kobe - I just wrote a custom code you can add add as action in one of your excel extended objects, you can check params for input and output variables, add any exception handling if you want to-

Dim ws as Object = GetWorksheet( handle, workbookname, worksheetname)

Dim xlRange As Object = ws.Range(Range_Cell)

Dim dt As New DataTable()

dt.Columns.Add("Hyperlinks")

For Each cell As Object In xlRange

If cell.Hyperlinks.Count > 0 Then

dt.Rows.Add(cell.Hyperlinks(1).Address)

End If

Next cell

Output_Collection = dt

Input Excel-

Output -

let me know if you find any difficulties with this.

------------------------------
Regards,

Mukesh K
------------------------------

RE: Extract hyperlink from excel cell

Moses19 — Thu, 18 Jan 2024 10:31:00 GMT

Thank you, I will look into it.

------------------------------
Moses Kobe
Developer
Discovery Limited
Johannesburg
0824899205
------------------------------