How to link a image from excel file using POI

Question

I am writting some text say "Pass" into excel file using cell.setCellValue("Pass"). Now I have to create a link to an image which locates at directory (C:\Users\UserName\DeskTop\image\test.jpg) from an excel.

When I click on text pass from excel file, then it should open the test.jpg image.

Please guide me/share to JAVA code to achieve this.

Thanks, Md Ashfaq

I am using Java code to achieve this. – mdashu Jul 29 '13 at 10:11 — mdashu, Jul 29 '13 at 10:11

score 1 · Answer 1 · edited May 23 '17 at 12:20

Ashfaq...Following is a method you can user for hyperlink the screenshot with the cell.

 public static void hyperlinkScreenshot(XSSFCell cell, String FileAddress){
    XSSFWorkbook wb=cell.getRow().getSheet().getWorkbook();
    CreationHelper createHelper = wb.getCreationHelper();
    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);
    Hyperlink hp = createHelper.createHyperlink(Hyperlink.LINK_FILE);
    FileAddress=FileAddress.replace("\\", "/");
    hp.setAddress(FileAddress);
    cell.setHyperlink(hp);
    cell.setCellStyle(hlink_style);
}

for details check here.

score 0 · Answer 2 · answered Jul 29 '13 at 09:59

0

Cell.Hyperlinks.Add Anchor:=Selection, Address:= _
        "C:\Users\UserName\DeskTop\image\test.jpg", TextToDisplay:="pass"

You can remove the setvalue as TextToDisplay can handle this...

answered Jul 29 '13 at 09:59

Vasim

3,052
3
35
56

i used the same code but its giving errors in eclipse. I am new to this POI, can u re-write the complete code with more clarity. I am using cell = row.createCell(Colposition) to get the cell value – mdashu Jul 29 '13 at 10:03

How to link a image from excel file using POI

2 Answers2