poi生成excel，插入图片

package com.sbr;

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 exportExcel {
 
  public static void main(String[] args) {
	  String picturePath ="C:\\Users\\neusoft\\Desktop\\1.jpg";
	try {
		HSSFWorkbook wb = new HSSFWorkbook();   
		HSSFSheet sheet1 = wb.createSheet("test picture"); 
		//画图的顶级管理器，一个sheet只能获取一个（一定要注意这点） 
        HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
//		插入图片
		writePicture(wb, sheet1,patriarch, picturePath,3,3);
		writePicture(wb, sheet1,patriarch, picturePath,3,4);
		writePicture(wb, sheet1,patriarch, picturePath,3,5);
		FileOutputStream fileOut;
		fileOut = new FileOutputStream("C:\\Users\\neusoft\\Desktop\\测试Excel.xls");
		wb.write(fileOut);   
		System.out.println("----Excle文件已生成------"); 
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}   
  } 
  /**
   * 
   * @param wb 文档对象
   * @param sheet1 sheet页
   * @param patriarch 图片对象
   * @param picturePath 图片路径
   * @param index 纵坐标
   * @param index1 横坐标
   */
  public static void writePicture(HSSFWorkbook wb,HSSFSheet sheet1,HSSFPatriarch patriarch,String picturePath,int index,int index1) {
	    FileOutputStream fileOut = null;   
	    BufferedImage bufferImg = null;   
	    //先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray  
	    try { 
	      ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();   
	      bufferImg = ImageIO.read(new File(picturePath));  
	      //图片后缀
	      String pictureType = picturePath.substring(picturePath.lastIndexOf(".")+1);
	      ImageIO.write(bufferImg, pictureType, byteArrayOut); 
	      //anchor主要用于设置图片的属性 
	      HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 255, 255,(short) index, index1, (short) index, index1);   
	      anchor.setAnchorType(3);   
	      //插入图片  
	      patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));  
	    } catch (Exception e) { 
	      e.printStackTrace(); 
	    }finally{ 
	      if(fileOut != null){ 
	        try { 
	          fileOut.close(); 
	        } catch (IOException e) { 
	          e.printStackTrace(); 
	        } 
	      } 
	    } 
  }
}