poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tewari,kuldeep" <kuldeep.Tew...@ind.xerox.com>
Subject RE: Cell hyperlink
Date Tue, 07 Jun 2005 09:13:42 GMT
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/


Mime
View raw message