poi 將圖片寫入EXCEL

List headlist = this.getCS_HEAD(allFactoryNo);
            HSSFSheet sheet = workbook.createSheet();
            sheet.setColumnWidth((short)0, 6000);
            sheet.setColumnWidth((short)1, 10000);
            HSSFRow row3 = sheet.createRow(3);
            HSSFPatriarch pa = sheet.createDrawingPatriarch();     ---增加多個圖片時只需創建一個對象
            HSSFRow row4 = sheet.createRow(4);
            HSSFCell cell40 = row4.createCell(0);
            cell40.setCellValue("物料編碼");
            HSSFCell cell41 = row4.createCell(1);
            cell41.setCellValue("物料名稱");
            for(int i=0;i<headlist.size();i++){
                Cs_head cshead = (Cs_head) headlist.get(i);
                SmbFile smbFile = new SmbFile("smb://erp002:erp002@IP/cac_phot/"+cshead.getProduct());---訪問網絡共享文件
                InputStream is = smbFile.getInputStream();
                int x1=0;
                int y1=0;
                int x2=x1+255;
                int y2=y1+255;
                HSSFClientAnchor anchor = new HSSFClientAnchor(x1,y1,x2,y2,(short)(2+(i*2)),0,(short)(4+(i*2)),2);
                anchor.setAnchorType(2);
                BufferedImage bi = ImageIO.read(is);
                ByteArrayOutputStream bout=new ByteArrayOutputStream();
                ImageIO.write(bi,"JPG",bout);
                pa.createPicture(anchor , workbook.addPicture(bout.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));