There is no method to remove a hyperlink from sheet. There are methid
to add/get but not to delete.
The collection of hyperlinks in XSSFSheet is private but you can
access it via reflection:
XSSFHyperlink link = ....; // the hyperlink to remove
XSSFSheet sheet = ...; // sheet containing the hyperlink
// access the private field XSSFSheet.hyperlinks
Field f = XSSFSheet.class.getDeclaredField("hyperlinks");
f.setAccessible(true);
List<XSSFHyperlink> hyperlinks = (List<XSSFHyperlink>)f.get(sheet);
hyperlinks.remove(link); // remove the link
Yegor
On Fri, Dec 7, 2012 at 1:08 PM, kurtosys.nicolas
<[email protected]> wrote:
> bumping ..
>
> i just can not believe my luck - does this silence means that it is not
> possible to remove a link from Excel with POI?
>
>
>
> -----
> Try our Fund Tools demo:
> http://www.kurtosys.com/fundtools
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/POI-Excel-2010-howto-remove-Hyperlink-from-cell-tp5711601p5711646.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> 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]
