excel中插入图片

1、创建excel

 

Workbook wb = new XSSFWorkbook();

Sheet sheet = wb.createSheet(sheetName);
            sheetNames.add(sheetName);
            mergeCells(sheet);
            Row row = sheet.createRow(0);

insertPicture(wb, sheet); 
wb.write(new FileOutputStream(filePath + "xxx.xls"));

2、插入图片方法

public void insertPicture(Workbook wb, Sheet sheet){
    Drawing drawing = sheet.createDrawingPatriarch();
    FileInputStream inputStream = null;
    byte[] imgtypes;
    try {
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        inputStream = new FileInputStream("xxx.png");
        byte[] buffer = new byte[1024];
        int len;
        while ((len = inputStream.read(buffer)) != -1) {
            baos.write(buffer, 0, len);
        }
        baos.flush();
        imgtypes = baos.toByteArray();
        ClientAnchor anchor = new XSSFClientAnchor(0, 0, 255, 255, (short) 1, 0, (short) 1 + 3, 5);
        int puctureIndex = wb.addPicture(imgtypes, Workbook.PICTURE_TYPE_JPEG);
        drawing.createPicture(anchor, puctureIndex);
    } catch (Exception e) {
        e.printStackTrace();
    }
    
}