分享: Apache POI 插入图片至 Excel 的两种方法

转载自品略图书馆  http://www.pinlue.com/article/2020/03/2319/3010048855212.html

 

方法 1 插入图片至坐标

[java]

ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();

BufferedImage bufferImg = ImageIO.read(new File(strAppRootPath + "images/" + "bxlogo.png"));

ImageIO.write(bufferImg, "png", byteArrayOut);

HSSFPatriarch patriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();

HSSFClientAnchor anchor = new HSSFClientAnchor(0, 150, 1000, 210, (short) 0, 0, (short) 1, 1);

patriarch.createPicture(anchor, workbook.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));

方法 2 插入图片至单元格，以及另一种图片载入方法，其实本质也一样

[java]

// 插入 PNG 图片至 Excel

String fileName = strAppRootPath + "images/" + "bxlogo.png";

InputStream is = new FileInputStream(fileName);

byte[] bytes = IOUtils.toByteArray(is);

int pictureIdx = workbook.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);

CreationHelper helper = workbook.getCreationHelper();

Drawing drawing = sheet.createDrawingPatriarch();

ClientAnchor anchor = helper.createClientAnchor();

// 图片插入坐标

anchor.setCol1(0);

anchor.setRow1(1);

// 插入图片

Picture pict = drawing.createPicture(anchor, pictureIdx);

pict.resize();