poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Trezise" <brian.trez...@intellidata.net>
Subject RE: Create relative-path hyperlink to external file
Date Wed, 19 Aug 2009 19:21:39 GMT
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
brian.trezise@intellidata.net
t: 720.524.4864
m: 303.809.9782


-----Original Message-----
From: Dave Fisher [mailto:dave@jmlafferty.com] 
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
>
> brian.trezise@intellidata.net
>
> t: 720.524.4864
>
> m: 303.809.9782
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message