poi读取excel模板，填充内容，添加图片并导出

public FileOutputStream illustrate() {
    FileOutputStream fileOut = null;
    BufferedImage bufferImg = null;
    try {
        ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
        //加载图片
        bufferImg = ImageIO.read(new File(E:/));
        ImageIO.write(bufferImg, "png", byteArrayOut);
        HSSFWorkbook wb = getWorkbook();
        HSSFSheet sheet = wb.getSheetAt(0);
        HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
        /**
         dx1 - the x coordinate within the first cell.//定义了图片在第一个cell内的偏移x坐标，既左上角所在cell的偏移x坐标，一般可设0
         dy1 - the y coordinate within the first cell.//定义了图片在第一个cell的偏移y坐标，既左上角所在cell的偏移y坐标，一般可设0
         dx2 - the x coordinate within the second cell.//定义了图片在第二个cell的偏移x坐标，既右下角所在cell的偏移x坐标，一般可设0
         dy2 - the y coordinate within the second cell.//定义了图片在第二个cell的偏移y坐标，既右下角所在cell的偏移y坐标，一般可设0
         col1 - the column (0 based) of the first cell.//第一个cell所在列，既图片左上角所在列
         row1 - the row (0 based) of the first cell.//图片左上角所在行
         col2 - the column (0 based) of the second cell.//图片右下角所在列
         row2 - the row (0 based) of the second cell.//图片右下角所在行
         */
        HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0,(short) 2, 2, (short) 2, 8);
        //插入图片
        patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));

        // 如果文件夹不存在则创建
        File pathfile = new File(fileUrl+"/download");
        if (!pathfile.exists()) {
            pathfile.mkdirs();
        }

        fileOut = new FileOutputStream(fileUrl+"download/excel.xls");
        // 输出文件
        wb.write(fileOut);
    } catch (Exception e) {
        e.printStackTrace();
    }
    return fileOut;
}