java 导出excel图片

最新推荐文章于 2024-05-29 15:29:20 发布

C_SanSui

最新推荐文章于 2024-05-29 15:29:20 发布

阅读量255

点赞数

文章标签： java excel python

本文链接：https://blog.csdn.net/C_SanSui/article/details/134327351

版权

java 使用EasyExcel导出图片到Excel

具体使用演示

导入依赖

 	<dependency>
        <groupId>com.alibaba</groupId>
         <artifactId>easyexcel</artifactId>
        <version>3.0.5</version>
   </dependency>

	/**
     * 生成有图片的excel
     * @param dataList  数据列表
     * @param fileName  生成文件路径
     */
    private void genImageExcel(HttpServletResponse response,List<Export> dataList, String fileName) throws IOException {
        if (CollectionUtils.isEmpty(demoDataList)) {
            return;
        }
        //图片列最大图片数
        AtomicReference<Integer> maxImageSize = new AtomicReference<>(0);
        demoDataList.forEach(item -> {
            if (CollectionUtils.isNotEmpty(item.getImagePathList()) && item.getImagePathList().size() > maxImageSize.get()) {
                maxImageSize.set(item.getImagePathList().size());
            }
        });
        //设置列长度所用类
        AutoColumnWidthStyleStrategy longWidth = new AutoColumnWidthStyleStrategy();

        demoDataList.forEach(item -> {
            WriteCellData<Void> writeCellData = new WriteCellData<>();
            if (CollectionUtils.isNotEmpty(item.getImagePathList())) {
                //每张图片间距
                Integer splitWidth = 2;
                //每张图片的长度
                Integer imageWidth = 80;
                //图片列的最大长度
                Integer sumWidth = maxImageSize.get() * (imageWidth + splitWidth);

                List<ImageData> imageDataList = new ArrayList<>();
                List<String> imagePathList = item.getImagePathList();
                for (int i = 1; i <= imagePathList.size(); i++) {
                    String path = imagePathList.get(i - 1);
                    Integer left = imageWidth * (i - 1) + i * splitWidth;
                    Integer right = sumWidth - imageWidth - left;
                    ImageData imageData = new ImageData();
                    try {
                        imageData.setImage(FileUtils.readFileToByteArray(new File(path)));
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                    imageData.setImageType(ImageData.ImageType.PICTURE_TYPE_PNG);
                    //距离单元格顶部距离
                    imageData.setTop(1);
                    //距离单元格底部距离
                    imageData.setBottom(1);
                    //距离单元格左边距离
                    imageData.setLeft(left);
                    //距离单元格右边距离
                    imageData.setRight(right);
                    imageData.setAnchorType(ClientAnchorData.AnchorType.DONT_MOVE_DO_RESIZE);
                    imageDataList.add(imageData);
                }
                writeCellData.setImageDataList(imageDataList);

                Map<String, Integer> zdyColumnWidth = new HashMap<>();
                //图片列名称，对应导出对象的列名称，图片列长度
                zdyColumnWidth.put("投诉图片", sumWidth / 6);
                longWidth.setZdyColumnWidth(zdyColumnWidth);
            }
            item.setWriteCellDataFile(writeCellData);
        });
        //写入数据
        EasyExcel.write(response.getOutputStream(), Export.class).registerWriteHandler(longWidth).registerWriteHandler(new SimpleRowHeightStyleStrategy((short)20,(short)35)).sheet("sheet表").doWrite(dataList);
    }

测试

  public void ExportExcel(HttpServletResponse response) throws IOException {
        String fileName = new String("导出-"+ System.currentTimeMillis() +".xlsx");
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("UTF-8");
        String formatFileName = URLEncoder.encode(fileName, "UTF-8");
        response.setHeader("Content-disposition", "attachment;filename=" + formatFileName );
        List<Export> exportList = service.getExportList();
        // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为用户表 然后文件流会自动关闭
        genImageExcel(response,exportList,fileName);
    }