If you meant referencing and not hyperlinking: for referencing cells from different sheet in same workbook, you do not need to specify the workbook name. ie. worksheet!cell will work just fine.
~ amol > -----Original Message----- > From: Vadim Gorlovetsky [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 22, 2005 8:53 AM > To: [email protected] > Subject: how set a hyperlink between worksheets within the same excel > file ? > > > I am looking for a way for linking between cells of different > worksheets > within the same excel file. > > The format of hyperlink [workboardName]worksheet!cell seems the only > option suitable for this. > > The only problem is a workboardname. > > If user saves a file on a filesystem, so a workboard name is a file > name, that application generates. > > Hyperlink works fine in this case. > > But when user chooses to open the document, generated by servlet, > > the name is changed with depend on number of versions in the > > "temporary files", so a file name changes from "reportXXXX.xls" > > to "reportXXXX[1..X].xls" and hyperlink does not work. > > > > Is there any way to detect/set a current workboard name ? > > > > Thanks > > --------------------------------------------------------------------- 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/
