1.添加POI依赖
<dependency><groupId>org.apache.poi</groupId><artifactId>poi</artifactId><version>3.17</version></dependency><!-- /artifact/org.apache.poi/poi-ooxml --><dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>3.17</version></dependency>
2.使用XSSFDrawing 插入图片到excel文件
参考java POI实现向Excel中插入图片 java 在Excel中插入图片 POI实现
XSSFDrawing patri = (XSSFDrawing) sheet.createDrawingPatriarch();// col1,row1 开始单元格 列和行,从0下标开始// col2,row2 开始单元格 列和行,从1下标开始XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 255, 255, col1, row1, col2, row2);patri.createPicture(anchor, workbook.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PNG));
import java.awt.image.BufferedImage;import java.io.ByteArrayOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import javax.imageio.ImageIO;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.xssf.usermodel.XSSFClientAnchor;import org.apache.poi.xssf.usermodel.XSSFDrawing;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class PoiExcelInsertPic {private static String excelFilePath = "C:/TEST/test.xlsx";private static String imagePath = "C:/TEST/image.PNG";// picture 原始位置 第13行 4,5两列private static short picCol1 = 3;private static short picCol2 = 5; // D and Eprivate static int picRow1 = 12;private static int picRow2 = 13; // 第13行public static void main(String[] args) {try {insertPic(excelFilePath, imagePath, picCol1, picRow1, picCol2, picRow2);} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}// 5.往Excel文件插入图片public static void insertPic(String filePath, String imagePath, short col1, int row1, short col2, int row2)throws IOException {FileOutputStream fileOut = null;BufferedImage bufferImg = null;// 先把读进来的图片放到一个ByteArrayOutputStream中,以便产生ByteArrayByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();bufferImg = ImageIO.read(new File(imagePath));ImageIO.write(bufferImg, "png", byteArrayOut);InputStream is = new FileInputStream(filePath);XSSFWorkbook workbook = new XSSFWorkbook(is);Sheet sheet = workbook.getSheetAt(0);XSSFDrawing patri = (XSSFDrawing) sheet.createDrawingPatriarch();// col1,row1 开始单元格 列和行,从0下标开始// col2,row2 开始单元格 列和行,从1下标开始XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 255, 255, col1, row1, col2, row2);patri.createPicture(anchor, workbook.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PNG));OutputStream out = new FileOutputStream(filePath);workbook.write(out);out.flush();out.close();is.close();System.out.println("----insert pic success------");}}