Read Hyperlink from the cell

[avinashy (Avinash)]

Description

Hi , i have a column in excel file with data as mentioned below. Sometimes the cell data will be text and some times it will be text that contains hyper link.(when i mouse over on the text it contains hyper link/ulr)
If i get text contains hyper link i want to read the URL. if not the normal text and store in variable.

Could you please help.

Thanks

Link

https://cloud.uipath.com

Date

2024-09-27

Related UiPath products

Studio

[ashokkarale]

@avinashy,

This would be helpful.

Read hyperlink from Excel without URL

just use a foreach loop here enumerable.Range(2,11) means start at row 2 and end at row 12 [image] then in the vba call , change the parameter to this [image] also, change the macro.txt to this to handle cells with NO hyperlinks (will output “No Link” if cell has no hyperlink) Function GetURL(cellAddress as string) As String On Error goto ErrorHandling: GetURL = Range(cellAddress).Hyperlinks(1).Address Exit Function ErrorHandling: GetURL = "No Link" End Function macro.txt (194 Bytes) te…

[avinashy (Avinash)]

Hi @ashokkarale I would like to pass the following details to get the hyperlink.
1.Excel file path - Fixed
2.Sheet Name - DYNAMIC VALUE
3.Cell address - DYNAMIC VALUE

In this case can you suggest .

Thanks

[ashokkarale]

@avinashy,

@avinashy

Sheet Name - DYNAMIC VALUE

Use Get Workbook Sheets activity to get all the sheets and pass the correct one you desire

@avinashy

DYNAMIC VALUE

Use Find/Replace Value activity to find the desired cell