POI (XSSFWorkbook) excel填充图片 Java

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>