Hyperlinks from Excel spreadsheet

[mwscott1]

I have an Excel spreadsheet with multiple columns. One of the columns (Name) contains a hyperlink. How do I get this to show as a hyperlink in QlikView. All of the hyperlinks are different and point to different sites. I have included a very simple example of my excel file.

[jonathandienst]

The problem is how to get the URLS. The LOAD returns only the visible text of the hyperlink.

If you can provide a way to fetch the URL, then you can show them in hyperlinks in qvw, as a text field with the syntax DisplayName & '<url>' & URL

(where DisplayName and URL the loaded fields)

Finally, select "Link" in the Representation in the Expressions tab.

HTH

Jonathan

[pgdavis2]

You can add this user defined function to your spreadsheet (in VBA)

In the cells you want to return the hyperlink address just use the function GetURL(cell)

Function GetURL(rng As Range) As String

    On Error Resume Next

    GetURL = rng.Hyperlinks(1).Address

End Function