Hi Kuldeep,
Tried you suggestion, it however was not working.
The value in cell has been changed to:
=#NAME!("http://www.ebi.uniprot.org/uniprot-srv";"view link")
Instead of giving me a hyperlink.
Any ideas?
Thanks a lot
Rui
>-----Original Message-----
>From: Tewari,kuldeep [mailto:[EMAIL PROTECTED]
>Sent: 07 June 2005 10:14
>To: POI Users List
>Subject: RE: Cell hyperlink
>
>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/
>
>
---------------------------------------------------------------------
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/
