private Drawing patriarch;
//BufferedImage是Image的实现,主要作用就是将一副图片加载到内存中
BufferedImage bufferImg = null;
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
//filepath图片路径
File file=new File(filepath);
if(file.exists()){
InputStream is;
try {
bufferImg = ImageIO.read(file);
ImageIO.write(bufferImg, "jpg", byteArrayOut);
//画图的顶级管理器,一个sheet只能获取一个(一定要注意这点)
is = new FileInputStream(path);
byte[] bytes = IOUtils.toByteArray(is);
//anchor主要用于设置图片的属性
ClientAnchor anchor = helper.createClientAnchor();
// 图片插入坐标
anchor.setCol1(colunm++);
anchor.setCol2(colunm);
anchor.setRow1(row.getRowNum());
anchor.setRow2(row.getRowNum()+1);
row.setHeightInPoints(80);
anchor.setDx1(0);
anchor.setDx2(0);
anchor.setDy1(0);
anchor.setDy2(0);
anchor.setAnchorType(2);
int pictureIdx = this.wb.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
patriarch.createPicture(anchor, pictureIdx);
fg=false;
val="";
} catch (Exception e1) {
}
}