Excel插入图片方法

/**
* 插入图片的方法
* @param wb表格对象
* @param sheet
* @param url图片的地址
* @throws IOException
*/
public void setImageLoog( HSSFWorkbook wb ,HSSFSheet sheet ,String url) throws IOException{
FileOutputStream fileOut = null;
BufferedImage bufferImg = null;
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
bufferImg = ImageIO.read(new File(url));
ImageIO.write(bufferImg, "png", byteArrayOut);
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 160, 255,(short) 5, 0, (short) 10, 0);
anchor.setAnchorType(3);
//插入图片
patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
}

转载于:https://www.cnblogs.com/LinXiaoHai/p/10930560.html