You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Brian Trezise <br...@intellidata.net> on 2009/08/19 19:46:35 UTC
Create relative-path hyperlink to external file
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
Re: Create relative-path hyperlink to external file
Posted by Dave Fisher <da...@jmlafferty.com>.
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
> 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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Create relative-path hyperlink to external file
Posted by Brian Trezise <br...@intellidata.net>.
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
Re: Create relative-path hyperlink to external file
Posted by Dave Fisher <da...@jmlafferty.com>.
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