base64位图片导出到excel指定位置

Drawing patriarch = sheet.createDrawingPatriarch();

//插入图片
BASE64Decoder decoder = new BASE64Decoder();
byte[] decoderBytes = new byte[0];
try {
decoderBytes = decoder.decodeBuffer(baseImg);
} catch (IOException e) {
e.printStackTrace();
}
//图片位置
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short)10, i+1, (short)(10+1), i+2);
// 插入图片
patriarch.createPicture((HSSFClientAnchor)anchor, workbook.addPicture(decoderBytes, HSSFWorkbook.PICTURE_TYPE_JPEG));

ByteArrayOutputStream out = new ByteArrayOutputStream();
//激活浏览器弹出窗口
response.setContentType(“application/x-msdownload”);
//浏览器弹出窗口显示的文件名
response.addHeader(“Content-Disposition”, “attachment;filename=” + dFileName);
workbook.write(out);
//in = new ByteArrayInputStream(out.toByteArray());
response.getOutputStream().write(out.toByteArray());