How to create a hyper link to a file in a cell?

[Flynn, Michelle M.]

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