Thanks Nick,
It hadn't occurred to me to unzip and read through the xml. By doing so I was
able to find what was expected, and I can write a method that will translate
the file path into the appropriate URL like form such as
("file:////network%20place/) and it works . It is unfortunate that it will not
just accept a java file path but this will work for me and I like it better
than the excel function method
Thanks again
David
-----Original Message-----
From: Nick Burch [mailto:[email protected]]
Sent: Monday, January 30, 2012 11:34 AM
To: POI Users List
Subject: RE: XSSF & Hyperlink to Directory
On Mon, 30 Jan 2012, Cross, David A. wrote:
> In Excel you can add a hyperlink to any cell and point it to any of the
> example directories above
Can you try unzipping the .xlsx files from POI and Excel, and seeing how
they differ in their hyperlinks? If memory serves, they get stored as
relations, but a grep (or similar) should let you find which file(s)
they're in
Nick
---------------------------------------------------------------------
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]
