1.导出Excel包含图片的核心代码
//画图的顶级管理器,一个sheet只能获取一个(注意)
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
row.setHeightInPoints(50);
sheet.setColumnWidth(cellColumn, 5000);
anchor = new HSSFClientAnchor(0, 0, 1023, 255, (short) cellColumn, i, (short) cellColumn, i);
anchor.setAnchorType(ClientAnchor.AnchorType.byId(3));
//bytes为文件流
patriarch.createPicture(anchor, wb.addPicture(bytes, HSSFWorkbook.PICTURE_TYPE_PNG));