Thanks, it worked!! POI and the user group is just fantastic. Darshak
-----Original Message----- From: PARIS Jean-Pierre RD-BIZZ-SOP [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 8:21 AM To: POI Users List Subject: RE : Linking to other sheets in the same workbook Hello! Fill the cell where you want to have your link with: cell.setCellFormula("HYPERLINK(\"#" + __TheNameOfTheDestSheet__ + "!" + __TheNameOfTheDestCell__ + "\", \"" + __LinkLabel__ + "\")"); In the Excel workbook, you will find for example: =HYPERLINK("#Sheet1!A1", "More...") depending on your locale for the function name and the argument separator. You'll have to set the cell style properly if you want blue undelined text. Hope this help, bye jp -----Message d'origine----- De : Darshak Mehta [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 juillet 2004 21:03 À : POI Users List Objet : RE: Linking to other sheets in the same workbook Hi Pavan, Thanks for the quick response. Unfortunately that doesn't serve my need. I want to create a workbook using HSSF with multiple sheets. The first sheet of this workbook will be a summary page with links to all the other pages. I need a mechanism to generate these links programmatically. Something similar to http://www.questionpro.com/marketing/SurveyReport-289.xls first sheet. Thanks, Darshak -----Original Message----- From: Pavan Guduru [mailto:[EMAIL PROTECTED] Sent: Thursday, July 22, 2004 11:58 AM To: POI Users List Subject: Re: Linking to other sheets in the same workbook Hello Darshak, try HSSFSheet workbook.getSheet(String "sheetName"); String workbook.getSheetName(int sheetIndex); HSSFSheet workbook.getSheetAt(int sheetIndex); int workbook.getSheetIndex(String sheetName); These functions should let you navigate between sheets and get to the required sheets and do the processing. Thanks Pavan Darshak Mehta <[EMAIL PROTECTED]> wrote: Hello, I recently started fiddling around with HSSF. Can someone give me pointers regarding linking cells to other sheets in the same workbook? We have a multi sheet workbooks and Need to navigate from the first page to other workbooks. Thanks in advance, Darshak --------------------------------- Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! --------------------------------------------------------------------- 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]
