Thanks! For your reply! But I need to read the cell hyperlink not to write in back in excel.
mxrblind wrote: > > > > swan wrote: >> >> Hi all, >> >> Can any body tell me which version of poi jar to use to get HSSFHyperlink >> class. I mean which version of poi jar is having HSSFHyperlink class. >> >> Thank you all in advance for your ans. >> >> Swan >> > > > I had that question while I was working on a report. I couldn't get the > right version with that implementation, but I came up with this for > solving the Link problem: > > String linkTo = "HYPERLINK(\"" + stringLink + "\",\"" + textToDisplay + > "\")"; > currentCell.setCellType(HSSFCell.CELL_TYPE_FORMULA); > currentCell.setCellFormula(linkTo); > > I hope this helps > -- View this message in context: http://www.nabble.com/HSSFHyperlink-tp18089380p18405053.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
