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