EasyExcel导出多sheet页

帆仔哟

已于 2023-07-11 15:46:17 修改

阅读量292

点赞数 1

分类专栏： Java导出文章标签： java idea

于 2023-05-09 09:56:55 首次发布

本文链接：https://blog.csdn.net/fanzaiyo/article/details/130573560

版权

Java导出专栏收录该内容

4 篇文章 0 订阅

订阅专栏

实现效果

依赖项

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel-core</artifactId>
            <version>3.2.1</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.2.1</version>
            <scope>compile</scope>
        </dependency>

controller层

    @PostMapping("/export")
    public void export(HttpServletResponse response, String vin) throws IOException {
        service.excelTest(response, vin);
    }

serviceImpl

    @Override
    public void excelTest(HttpServletResponse response, String vin) {
        // 车身信息
        PlanCarInfo planCarInfos = stopMapper.getPlanCarInfoByVin(vin);
        // 过点记录
        List<AviPassRecordDTO> aviPassRecords = stopMapper.getAviPassRecordInfoByVin(vin);
        // 化验参数
        List<QualityParamAssayDTO> paramAssConfigs = assayService.findAllParamAssConfigInfo(vin);

        Map<String,Object> map = new HashMap<>();
        map.put("carType",planCarInfos.getBodyType());
        map.put("carColor",planCarInfos.getColorType());
        map.put("carConfig",planCarInfos.getConfigType());
        map.put("tpsCode",planCarInfos.getTpsCode());
        map.put("vin",planCarInfos.getVin());
//

        response.addHeader("Content-Disposition", "filename=" + "模板导出.xlsx");
        //设置类型，扩展名为.xls
        response.setContentType("application/vnd.ms-excel");

        ExcelWriter writer = null;
        try {
            // 车身信息 + 过点记录
            writer = EasyExcel.write(response.getOutputStream()).withTemplate(new ClassPathResource("质量追踪.xlsx").getInputStream()).build();
            WriteSheet writeSheet1 = EasyExcel.writerSheet(0).build();
            writer.fill(map, writeSheet1);
            writer.fill(aviPassRecords, writeSheet1);
            // 化验参数
            WriteSheet writeSheet2 = EasyExcel.writerSheet(1).head(QualityParamAssayDTO.class).build();
            writer.write(paramAssConfigs,writeSheet2);
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (writer != null) {
                writer.finish();
            }
        }
    }