poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yegor Kozlov <yegor.koz...@dinom.ru>
Subject Re: Creating hyperlink on the image inserted into the sheet using HSSF or XSSF.
Date Tue, 10 Apr 2012 07:24:56 GMT
The short answer is no, you cannot assign hyperlinks to images and
other graphic objects (shapes,  word art, etc.). Neither HSSF nor XSSF
support it.

In theory, you can do it in XSSF: create a sample .xlsx file with a
hypelirnk assigned to an image, unzip it and see how Excel sets such
hyperlinks.
Then you can construct the required xml with low-level xml beans.

Yegor

On Mon, Apr 9, 2012 at 11:36 PM, Vitaly Rozhkov
<vitaly.rozhkov@googlemail.com> wrote:
> Hi All,
> I have the question: can I attach hyperlink to the image not to the cell
> content?
> I need to get hyperlink opened when I click on the image in the Excel
> document.
> I can create hyperlink when I edit the document in MS Excel 2003 by right
> button clicking on image and selecting 'hyperlink'. But how can I do it
> using Apache POI HSSF or XSSF API?

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


Mime
View raw message