Hello all, I have an excel sheet where a column is full of hyperlinks. Whenever I grab this column, it only gets the displayed text , no matter what settings I have the read range activity as. But I need the full hyperlink. Example: [image] Currently I’m only able to return Test_MasterProject_21…

I found the issue, even though the cells were operating as hyperlinks, technically they were formulas (=hyperlink(X,y,z)). I used the get formulas activity and parsed out what I needed.

How do I get excel hyperlinks into a datatable?

Help Studio

Ali_Murtaza (Ali Murtaza) March 21, 2024, 4:40pm 2

You can try this:

Topic		Replies	Views
How to read hyperlink text from excel cell Help datatable , excel	4	4189	January 20, 2020
Retrieve hyperlink from a value in a cell in Excel Help excel , activities	21	4170	January 5, 2021
Need to Extract Hyperlinks from a given Datatable along with some non hyperlink columns Activities excel , activities , question	6	846	November 20, 2024
Excel - Read hyperlinks embedded in an excel (without external library) Activities excel , activities , studio , question	3	1236	July 9, 2023
Following links from cells in excel Studio excel	2	592	November 4, 2022

How do I get excel hyperlinks into a datatable?

Related topics