XSSFWorkbook xw = new XSSFWorkbook(new File("D:/test.xlsx"));//读取excel模板 xlsx格式
XSSFSheet sheet = xw.getSheetAt(0);//指定sheet
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream(); // byte 数组
BufferedImage bufferImg = ImageIO.read(new File("D:\\timg.jpg")); // 图片文件
ImageIO.write(bufferImg, "jpg", byteArrayOut); //图片写入byte数组
XSSFDrawing drawing = sheet.createDrawingPatriarch(); //画图器 一个sheet只能一个
XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, 1, 1, 4, 7);//位置 后四个参数: 前两个: 图片左上角的X,Y坐标 后两个:图片右下左上角的X,Y坐标
anchor.setAnchorType(AnchorType.DONT_MOVE_AND_RESIZE);
drawing.createPicture(anchor, xw.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_JPEG));//执行
FileOutputStream out = new FileOutputStream(new File("D:/AAA.xlsx"));
xw.write(out);//写出
MAVEN 依赖
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>