天天看點

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;
}