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]
