EasyExcel导出

    EasyExcel是一个基于Java的简单、省内存的读写Excel的开源项目。在尽可能节约内存的情况下支持读写百M的Excel。

导入依赖：

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

实现：勾选数据导出

控制层方法： 其中传递的参数为前端查询获取到的数据

    @PostMapping("/exportExcel")
    public void exportExcel(@RequestBody List<CamasAnalysisViolationRepairRespVO> respVOList, HttpServletResponse response) throws IOException {
        violationRepairService.exportExcel(respVOList, response);
    }

CamasAnalysisViolationRepairRespVO实体类：

@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
public class CamasAnalysisViolationRepairRespVO extends CamasAnalysisViolationRepairBaseVO {
    private Integer monitorItem;

    private String jcxmname;//监测项目名称

    private String wgname;

    //监测项目名称+违规项
    private String jcxmNameWgx;

    private String wgip;

    private Long ipSegmentInfoId;

    private String macdz;

//    private List<CamasSysTagDO> tagList;
}

@Data
public class CamasAnalysisViolationRepairBaseVO {
    private Long id;

    private