import java.io.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.usermodel.HSSFHyperlink;
public class CreateCellHyperlink {
public static void main(String[] args) throws Exception{
HSSFWorkbook my_workbook = new HSSFWorkbook();
HSSFSheet my_sheet = my_workbook.createSheet("Cell Hyperlink");
HSSFHyperlink url_link=new HSSFHyperlink(HSSFHyperlink.LINK_URL);
HSSFHyperlink file_link=new HSSFHyperlink(HSSFHyperlink.LINK_FILE);
HSSFHyperlink email_link=new HSSFHyperlink(HSSFHyperlink.LINK_EMAIL);
url_link.setAddress("http://www.google.com");
file_link.setAddress("file:///c://test.csv");
email_link.setAddress("mailto:test@gmail.com");
Row row = my_sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("Take me to Google");
cell.setHyperlink(url_link);
row = my_sheet.createRow(1);
cell = row.createCell(1);
cell.setCellValue("Click to Open the file");
cell.setHyperlink(file_link);
row = my_sheet.createRow(2);
cell = row.createCell(2);
cell.setCellValue("Send an Email");
cell.setHyperlink(email_link);
FileOutputStream out = new FileOutputStream(new File("C:\\cell_hyperlink_example.xls"));
my_workbook.write(out);
out.close();
}
}