This worked like a charm! Thanks Lou. Thanks, Michelle
-----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Friday, September 16, 2011 9:25 AM To: POI Users List Cc: [email protected] Subject: Re: How to create a hyper link to a file in a cell? This is something I put in mine for a mail link (hope it helps): CellStyle hlink_style = wb.createCellStyle(); Font hlink_font = wb.createFont(); hlink_font.setUnderline(Font.U_SINGLE); hlink_font.setColor(IndexedColors.BLUE.getIndex()); hlink_style.setFont(hlink_font); hlink_style.setLocked(false) ; Hyperlink link = null; cell = sheet.createRow(2).createCell((short)0); cell.setCellValue("E-Mail For Help"); link = factory.createHyperlink(Hyperlink.LINK_EMAIL); link.setAddress("mailto:[email protected]?subject=General_Help";); cell.setHyperlink(link); cell.setCellStyle(hlink_style); -Lou "Flynn, Michelle M." <[email protected]> wrote on 09/15/2011 10:51:16 AM: > I've had success with creating a LARGE SXSSFWorkbook with no memory > errors ( THANKS guys! ). I've been able to create Sheets, rows and > cells. Now I've come to a cell I don't know how to create. I need to put > a hyper link into a cell with a file name in it, it will actually be a > jpg file or some other type of image file. When the link is selected in > the outputted excel file I'd like the default image program to display > the file. > > I'm using an SXSSFWorkbook to resolve a memory issue with very large > output. > > Here are the types of sheet, row and cell I've been using > > import org.apache.poi.ss.usermodel.Row; > > import org.apache.poi.ss.usermodel.Sheet; > > import org.apache.poi.ss.usermodel.Cell; > > import org.apache.poi.ss.usermodel.CellStyle; > > import org.apache.poi.ss.usermodel.CreationHelper; > > > > I see that under createHelper there is a createHyperlink( int type ), > but how do I use that and is that the correct thing to be using? > > createHelper = outputWorkbook.getCreationHelper(); > > > > I only have a few days left at this company and would like to be able to > wrap this up or at least be able to tell someone how to do this. Any > help would be greatly appreciated! > > > > Thanks > > Michelle > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
