It does - here is the example:

http://poi.apache.org/spreadsheet/quick-guide.html#Hyperlinks

Dave

On Aug 19, 2009, at 12:21 PM, Brian Trezise wrote:

If I manually create a hyperlink in an excel and then read it with poi, it returns a java.lang.String showing the display text of the link. Does poi
not recognize excel hyperlinks?

-----------------------------
Brian Trezise
IntelliData, Inc.
Staff Software Engineer
[email protected]
t: 720.524.4864
m: 303.809.9782


-----Original Message-----
From: Dave Fisher [mailto:[email protected]]
Sent: Wednesday, August 19, 2009 11:55
To: POI Users List
Subject: Re: Create relative-path hyperlink to external file

Have a look at
http://poi.apache.org/apidocs/org/apache/poi/common/usermodel/Hyperlink.html

You should be able to create one.

One thing to do is to create a simple Excel document that does what
you want and then read it in POI to see how the Hyperlink's Address is
created by Excel. You can then set your hyperlinks the same way.

Regards,
Dave

On Aug 19, 2009, at 10:46 AM, Brian Trezise wrote:

Hi, I'm needing to know how to go about using POI to create a
relative-path
hyperlink to an external pdf file (ie, the hyperlink path would be
relative
to the location of the excel file).



What I'm hoping to do is to be able to open a pdf document from
within the
generated excel spreadsheet by clicking a link, preferably have it
open
directly to a specific page.



Any thoughts?



-----------------------------

Brian Trezise

IntelliData, Inc.

Staff Software Engineer

[email protected]

t: 720.524.4864

m: 303.809.9782





---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to