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 <[EMAIL PROTECTED]> 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:[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/ > > __________________________________ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ --------------------------------------------------------------------- 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/
