POI:将图片导出到Excel

POI什么的在此我就不多作介绍了，在POI中生成图片有关的有HSSFPatriarch和HSSFClientAnchor，前者负责在表中创建图片，后者负责设置图片的大小位置。

/**
* 根据输出路径及要导出的图片文件生成EXCEL
* @param desPath
* @param file
*/
private void createSheet(String desPath, String file) {
try {
// 创建图片页
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("模型图");
ByteArrayOutputStream outStream = new ByteArrayOutputStream();
// 将图片写入流中
BufferedImage bufferImg = ImageIO.read(new File(file));
ImageIO.write(bufferImg, "PNG", outStream);
// 利用HSSFPatriarch将图片写入EXCEL
HSSFPatriarch patri = sheet.createDrawingPatriarch();
HSSFClientAnchor anchor = new HSSFClientAnchor(5, 5, 5, 5,
(short) 5, 2, (short) 15, 25);
patri.createPicture(anchor, workbook.addPicture(
outStream.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));
workbook.write(new FileOutputStream(desPath));
} catch (Exception e) {
final String message = e.toString();
Display.getDefault().syncExec(new Runnable() {
@Override
public void run() {
MessageBox box = new MessageBox(Display.getDefault().getActiveShell(), SWT.ERROR);
box.setText("导出错误");
box.setMessage(message);
box.open();
}
});
e.printStackTrace();
}
}

评论

2 楼 18335864773 2017-06-05  

我们用的是pageoffice插件生成excel，别人推荐使用的。可以在线打开，编辑，保存excel文档。很多人说比 poi生成excel 简单。

1 楼 rensanning 2012-05-23  

FileInputStream jpeg = new FileInputStream(file);
byte[] bytes = IOUtils.toByteArray(jpeg);
int pictureIndex = workbook.addPicture(bytes, HSSFWorkbook.PICTURE_TYPE_JPEG);
jpeg.close();

HSSFCreationHelper helper = (HSSFCreationHelper) workbook.getCreationHelper();

HSSFClientAnchor clientAnchor = helper.createClientAnchor();
clientAnchor.setCol1(3);
clientAnchor.setRow1(2);

HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
HSSFPicture picture = patriarch.createPicture(clientAnchor, pictureIndex);
picture.resize();