XSSFWorkbook Excel导出图片

大海星辰798

已于 2023-10-18 10:02:25 修改

阅读量378

点赞数

分类专栏： java 文章标签： excel java spring

于 2023-02-16 14:48:37 首次发布

本文链接：https://blog.csdn.net/qq_27413769/article/details/129062019

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


if (object instanceof List<?>) {
                    // 针对图片导出
                    List<?> picList = ((List<?>) object);
                    for (int i=0;i<picList.size();i++) {
                        // 图片类型为byte
                        byte[] byteArr = (byte[]) picList.get(i);
                        InputStream in = new ByteArrayInputStream(byteArr);
                        BufferedImage bufferedImage = ImageIO.read(in);
                        int width = bufferedImage.getWidth();
                        int height = bufferedImage.getHeight();
                        int anchorX,anchorY;
                        // 计算图片缩放比例
                        anchorX = 1000;
                        anchorY = (int) (1000 * ((double) height / (double) width));
                        anchorX = anchorX * HSSFShape.LINEWIDTH_DEFAULT;
                        anchorY = anchorY * HSSFShape.LINEWIDTH_DEFAULT;
                        XSSFDrawing xssfDrawing = sheet.createDrawingPatriarch();
                        // 13+i 为从第几列插入，rowIndex + 2为第几行
                        XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, anchorX, anchorY, 13+i,
                                rowIndex + 2, 13+i, rowIndex + 2);
//XSSFWorkbook workbook
                        xssfDrawing.createPicture(anchor,
                                workbook.addPicture(byteArr, XSSFWorkbook.PICTURE_TYPE_PNG));
                    }
                }