Cell hyperlink

[Rui Wang <Ru...@newcastle.ac.uk>]

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/