read hyperlinks from an excel sheet

[WeberM]

Hello,

is it possible to read the path of a hyperlink from an excel sheet?

thanks in advance

Markus

[Mathan]

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.hyperlink_members(v=office.11...

SubAddress method will help you i think. Not sure. Try it out and get back.

Mathan

[WeberM]

Mathan, thank you for the fast response.

I tried it now but I'm not sure how to create a SubAddress Method.

I attached a picture to show you what I've done.

[Eric_MyNi]

Sorry to add to an old thread, but I have the same problem and this is the thread that keeps coming up in my searches.

Does anyone have an example of how to read/get a hyperlink from a cell in an excel file?

It seems like it would be very easy and all over the forum, but I have not figured it out.  Tech Help is trying, but so far hasn't been able to answer it.

I have attached what I have.  My problem appears to be at the Index input of the Hyperlinks Invoke node.   What sould the input be?  I haven't been able to find documentation for it.  Value 2 does show the text of my link.  I converted a few indicators to constants so you can see them.

Hyperlinks gives the error -2147352565, which leads me to http://digital.ni.com/public.nsf/allkb/A79AEB73AE85CCC286256CED0082294E which is about index on the sheets invoke node.  Oviously related, but not really helpful (to me).

Thanks.

[tstackler]

I was trying to figure this out today and since I couldn't find the solution, here it is for posterity.