poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rui Wang" <Rui.W...@newcastle.ac.uk>
Subject RE: Cell hyperlink
Date Tue, 07 Jun 2005 10:05:52 GMT
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:kuldeep.Tewari@ind.xerox.com] 
>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:Rui.Wang@newcastle.ac.uk]
>Sent: Tuesday, June 07, 2005 2:10 PM
>To: poi-user@jakarta.apache.org
>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: poi-user-unsubscribe@jakarta.apache.org
>Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message