POI を使用して Excel に画像を挿入する

Jan 23, 2018

Java で POI パッケージを使用して Excel を出力するときに画像を挿入する方法。

try {
    FileInputStream images = new FileInputStream("/path/to/file.png");
    
    final Drawing drawing = sheet.createDrawingPatriarch();
    final ClientAnchor anchor = helper.createClientAnchor();
    anchor.setAnchorType(ClientAnchor.MOVE_AND_RESIZE );
    final int pictureIndex = workbook.addPicture(
        IOUtils.toByteArray(images),
        Workbook.PICTURE_TYPE_PNG
    );
    anchor.setCol1(1);
    anchor.setRow1(1);
    final Picture picture = drawing.createPicture(anchor, pictureIndex);
    picture.resize(1.0, 1.0);
} catch (Exception ex) {
    ex.printStackTrace();
}

参考文献

• Insert image in column to excel using Apache POI
• Busy Developers' Guide to HSSF and XSSF Features

poi java