使用POI向excel中寫入圖片的java代碼
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));
本文由用戶 m4ed 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!