用POI向Excel中写入多张图片

来源：互联网发布：淘宝有趣的店编辑：程序博客网时间：2024/05/22 01:41

用POI写入图片的方法，可是当把方法改写为写入多张图片是，出现问题了。

结果时只写入了一张图片。

经过调查，终于发现了问题所在。供大家参考。

package com.poi.demo;

import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import javax.imageio.ImageIO;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ImageToExcel {

private HSSFWorkbook wb = null;

private HSSFSheet sheet = null;

private HSSFPatriarch patriarch = null;

public ImageToExcel() {

  wb = new HSSFWorkbook();
  sheet = wb.createSheet("mysheets1");
  sheet.setDefaultColumnWidth((short) 2);
  patriarch = sheet.createDrawingPatriarch();
}

//这个是从网上找到的方法

private void setImageToCell(short col1, int row1, short col2, int row2,
String imagePath) {

BufferedImage bufferImg = null;
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();

  try {
   bufferImg = ImageIO.read(new File(imagePath));
   ImageIO.write(bufferImg, "jpg", byteArrayOut);

//能否写多张图片，关键在与HSSFPatriarch patriarch 这个变量。写多张图片时，

//HSSFPatriarch patriarch 应该时一个对象，不应该每次多新创建对象。
   //HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
   HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255, col1, row1, col2, row2);
   anchor.setAnchorType(2);

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

  } catch (IOException e) {
   e.printStackTrace();
  }
}

public void createExcel() {

FileOutputStream fileOut = null;

try {

   setImageToCell((short) 1, 1, (short) 8, 6, "D:/fruit.jpg");
   setImageToCell((short) 1, 8, (short) 8, 13, "D:/fruit.jpg");
   setImageToCell((short) 1, 15, (short) 8, 20, "D:/fruit.jpg");

   fileOut = new FileOutputStream("D:/myexcel.xls");
   wb.write(fileOut);
  } catch (FileNotFoundException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  } finally {

   if (fileOut != null) {
    try {
     fileOut.close();
    } catch (IOException e) {
     e.printStackTrace();
    }
   }
  }
}

public static void main(String[] args) {

ImageToExcel excel = new ImageToExcel();
excel.createExcel();
}
}