java : poi 3.10 实现向Excel中插入图片

参考 file:///poi-3.10-FINAL/docs/spreadsheet/quick-guide.html#Images

Excel_imageTest.java

import java.io.*;
import java.util.*;

import org.apache.commons.io.IOUtils;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Excel_imageTest {
    public static void main(String[] args) {
	  try {
	 	//create a new workbook
	    Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();
	
	    //add picture data to this workbook.
	    InputStream is = new FileInputStream("66001.png");
	    byte[] bytes = IOUtils.toByteArray(is);
	    int pictureIdx = wb.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
	    is.close();
	
	    CreationHelper helper = wb.getCreationHelper();
	
	    //create sheet
	    Sheet sheet = wb.createSheet("Sheet1");
	
	    // Create the drawing patriarch.  This is the top level container for all shapes. 
	    Drawing drawing = sheet.createDrawingPatriarch();
	
	    //add a picture shape
	    ClientAnchor anchor = helper.createClientAnchor();
	    //set top-left corner of the picture,
	    //subsequent call of Picture#resize() will operate relative to it
	    anchor.setCol1(3);
	    anchor.setRow1(2);
	    Picture pict = drawing.createPicture(anchor, pictureIdx);
	
	    //auto-size picture relative to its top-left corner
	    pict.resize();
	
	    //save workbook
	    String file = "66001.xls";
	    if(wb instanceof XSSFWorkbook) file += "x";
	    FileOutputStream fileOut = new FileOutputStream(file);
	    wb.write(fileOut);
	    fileOut.close();
	  } catch (IOException e) {
	 	e.printStackTrace();
	  }
	}
}