Hi Rui, Try this
String linkFormula = "HYPERLINK(\"http://www.ebi.uniprot.org/uniprot-srv\",\"view link\")"; cell.setCellFormula(linkFormula); regards. Kuldeep. -----Original Message----- From: Rui Wang [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 2:10 PM To: [email protected] Subject: Cell hyperlink Hi all, I am writing a piece of code to automat the filling of the cells in a worksheet. However, I wish to be able to generate a hyperlink for the content, which I wrote into the cell. For instance, if a cell contains a string "Q11111", when I click on this string, a web browser will pop up and display the web page I wish to link to. To do this, I tired two different approach: First: //String linkFormula = "HYPERLINK(\"http://www.ebi.uniprot.org/uniprot-srv\";)"; //cell.setCellFormula(linkFormula); Second: //String linkFormula = "HYPERLINK(\"http://www.ebi.uniprot.org/uniprot-srv\";),\"view link\""; //cell.setCellFormula(linkFormula); But neither of them are working, so I wonder whether this is the right way to do. Any comments are welcome. Thanks Rui --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
