Apache POI向excel中插入图片

1. //先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray   
2.       ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();;   
3.       BufferedImage bufferImg = ImageIO.read(new File("ok.jpg"););;   
4.       ImageIO.write(bufferImg,"jpg",byteArrayOut);;   
5.   
6. //读进一个excel模版   
7. FileInputStream fos = new FileInputStream(filePathName+"/stencil.xlt");;    
8. fs = new POIFSFileSystem(fos);;   
9. //创建一个工作薄   
10. HSSFWorkbook wb = new HSSFWorkbook(fs);;   
11. HSSFSheet sheet = wb.getSheetAt(0);;   
12. HSSFPatriarch patriarch = sheet.createDrawingPatriarch();;   
13. HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,1023,255,(short); 0,0,(short);10,10);;        
14. patriarch.createPicture(anchor , wb.addPicture(byteArrayOut.toByteArray();,HSSFWorkbook.PICTURE_TYPE_JPEG););;