java导出excel 图片_将图片导出到Excel中（poi导出）

1.图片存储在数据库中，字段类型是blob。

2.

import java.awt.p_w_picpath.BufferedImage;

import java.io.ByteArrayOutputStream;

import org.hibernate.lob.SerializableBlob;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;

import org.apache.poi.hssf.usermodel.HSSFPatriarch;

SerializableBlob blob = (SerializableBlob)图片字段值;

HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,0,0,(short) 0,1,(short)1,6);

anchor.setAnchorType(2);

HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();

try {

BufferedImage  bufferImg = ImageIO.read(blob.getBinaryStream()) ;

ImageIO.write(bufferImg,"jpg",byteArrayOut);

patriarch.createPicture(anchor , workBook.addPicture(byteArrayOut.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));

} catch (Exception e) {

e.printStackTrace();

}