The problem is not that Excel will not accept a long URL. It won't accept a long =HYPERLINK formula. The problem is that a formula can be no longer than 256 bytes once it is compiled.
Try this: Put the URL into a cell (such as A4) as a String. You might want to hide this cell Use a Hyperlink formula that references the content of the cell instead of trying to put the long string into the formula A5 = =HYPERLINK( A4, "View Link") I haven't tried it with POI, but I bet it will work. -----Original Message----- From: Chris Cheshire [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:49 PM To: POI Users List Subject: Re: HYPERLINK formula problems Sam, There are a couple of options here, depending on what level access you have to the application you are linking to. 1) Is the URL a static URL, and not dynamically built? If so, make a "tiny url" (www.tinyurl.com) out of it, and insert it into the cell 2) If you can modify the web application without disrupting it, change it so the URLs are smaller. However, if both of these situations don't apply, then you are stuck because if Excel won't accept the long URL, then POI won't help either :( Chris Sam Maina wrote: > Yes that's was typo. > > So it would be right to say that Excel formula is limited to a certain > length? > Does anyone have any idea how I can work around this? > > Sam Maina > Web Developer > Knovel Corporation > (607) 773 1840 ext 670 > [EMAIL PROTECTED] > > > -----Original Message----- > From: Srinadh Karumuri [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 1:02 PM > To: POI Users List > Subject: Re: HYPERLINK formula problems > > > It's probably a typo but I see that there is a missing '\' in the first > link after HYPERLINK( > > BTW, I copy pasted the second function in excel and it complains that > the > formula is too long. > > Hope it helps. > Sri > > At 04:23 PM 2/25/2004, you wrote: > >>I am having problems with the HSSFCell setCellFormula() method. I guess > > >>the question is: Is there a limitation on the number of characters that > > >>can be used with the HYPERLINK formula? >> >>This link works: >>"HYPERLINK("http://www.knovel.com/knovel2/Show_HotLink.jsp?RecordID=208 >>7 >>40003 >><http://www.knovel.com/knovel2/Show_HotLink.jsp?RecordID=208740003&Link > > I > >>D=208747112&SetID=5412523&Maina=small_structure\> >>&LinkID=208747112&SetID=5412523&Maina=small_structure\",\"view link\")" >> >> but this one does not. >>"HYPERLINK(\"http://www.knovel.com/knovel2/Show_HotLink.jsp?SpaceID=101 > > 10 > <http://www.knovel.com/knovel2/Show_HotLink.jsp?SpaceID=10110&NodeID=188 > >>4630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Maina=small_s > > t > >>ructure\> >>&NodeID=1884630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Ma > > i > >>na=small_structure\",\"view link\")"; >> >>Sam Maina > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
