方法 1 插入圖片至坐標(biāo)
- ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
- BufferedImage bufferImg = ImageIO.read(new File(strAppRootPath + "images/" + "bxlogo.png"));
- ImageIO.write(bufferImg, "png", byteArrayOut);
-
- HSSFPatriarch patriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
- HSSFClientAnchor anchor = new HSSFClientAnchor(0, 150, 1000, 210, (short) 0, 0, (short) 1, 1);
- patriarch.createPicture(anchor, workbook.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));
方法 2 插入圖片至單元格，以及另一種圖片載入方法，其實(shí)本質(zhì)也一樣
- // 插入 PNG 圖片至 Excel
- String fileName = strAppRootPath + "images/" + "bxlogo.png";
-
- InputStream is = new FileInputStream(fileName);
- byte[] bytes = IOUtils.toByteArray(is);
-
- int pictureIdx = workbook.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
-
- CreationHelper helper = workbook.getCreationHelper();
- Drawing drawing = sheet.createDrawingPatriarch();
- ClientAnchor anchor = helper.createClientAnchor();
-
- // 圖片插入坐標(biāo)
- anchor.setCol1(0);
- anchor.setRow1(1);
- // 插入圖片
- Picture pict = drawing.createPicture(anchor, pictureIdx);
- pict.resize();
blog.csdn.NET/joyous/article/details/9664739
Q群討論：236201801
本站僅提供存儲服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請
點(diǎn)擊舉報(bào)。
