poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lakshmi <lakshmi...@yahoo.com>
Subject RE: Cell hyperlink
Date Tue, 07 Jun 2005 19:50:16 GMT
Hi,
There is the limitation in the url string specified in
the HYPERLINK() method.

Please check the following link, there is a different
approach given for the same problem.
http://java2.5341.com/msg/54171.html 

Hope this helps!
Regards,
Lakshmi

--- Rui Wang <Rui.Wang@newcastle.ac.uk> wrote:

> 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/
> 
> 



		
__________________________________ 
Discover Yahoo! 
Use Yahoo! to plan a weekend, have fun online and more. Check it out! 
http://discover.yahoo.com/

---------------------------------------------------------------------
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