[JAVA] Apache POI excel내부에 image 삽입

요청사항 중에 grid 데이터에 이미지를 엑셀에 삽입하는 기능을 구현하기를 요청하였다. 

찾아보니 excel export 기능은 보통 POI라이브러리를 이용한다고 한다.

int cellIndex=8;
Drawing drawing = sheet.createDrawingPatriarch();
for(FilesVO fileVO : filesVOList){
	ExcelUtil.setImgCell(workbook, sheet, row.getRowNum(), cellIndex++, opinionUploadPath+"/"+fileVO.getFileReName(), drawing);
    //Workbook interface, Sheet interface, 행, 열, 이미지 파일 경로, Drawing interface
}

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.ss.usermodel.Drawing;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.util.IOUtils;

import java.io.FileInputStream;
import java.io.InputStream;

public class ExcelUtil {
    public static void setImgCell(Workbook workbook, Sheet sheet, int row, int cell, String fileName, Drawing drawing) throws Exception{
        InputStream is = new FileInputStream(fileName);
        byte[] bytes = IOUtils.toByteArray(is);
        int pictureIdx = workbook.addPicture(bytes, Workbook.PICTURE_TYPE_JPEG);
        is.close();

        HSSFClientAnchor anchor = new HSSFClientAnchor(2,2,1021,253,(short)cell,(row),(short)cell,(row));
        anchor.setAnchorType(1);
        drawing.createPicture(anchor, pictureIdx);
    }
}

https://godbasic.tistory.com/entry/POI-Image

POI Image