You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by capira <ca...@gmail.com> on 2011/11/25 10:38:17 UTC
Reading an hiperlink in a excel cell
Hello.
I'm trying to get the link from an hiperlink test which is a cell, but I
can't find the way. I have try to access it throught the RichFormat
properties, but they are all related to format and style. Probably it is
something really easy, but I can't find the way.
Could anyone help me? Any ideas?
Thanks in advance.
Regards.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-an-hiperlink-in-a-excel-cell-tp5022353p5022353.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Reading an hiperlink in a excel cell
Posted by Nick Burch <ni...@alfresco.com>.
On Sat, 26 Nov 2011, capira wrote:
> I've been thinking about something more complex like a text with several
> hyperlinks. Which will be the solution in these case?
I don't think we expose support for that, sorry. It'll be down in the
record level, but nothing bubbles up into the usermodel
You'd probably find it much easier to do with XSSF (the .xlsx file format
is a bit saner for hyperlinks), if you can get your source data in .xlsx
rather than .xls?
Otherwise, if you do get it working by digging down into the hssf records,
we'd love a patch!
Thanks
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Reading an hiperlink in a excel cell
Posted by capira <ca...@gmail.com>.
Hi Nick Burch-11.
Thanks a lot for the quick reply. That was exactly what I was looking for,
or at least apply to my problem.
I've been thinking about something more complex like a text with several
hyperlinks. Which will be the solution in these case?
Best Regards.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-an-hiperlink-in-a-excel-cell-tp5022353p5024639.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Reading an hiperlink in a excel cell
Posted by Nick Burch <ni...@alfresco.com>.
On Fri, 25 Nov 2011, capira wrote:
> I'm trying to get the link from an hiperlink test which is a cell, but I
> can't find the way.
The quick guide covers this:
http://poi.apache.org/spreadsheet/quick-guide.html#Hyperlinks
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org