EasyExcel专栏

使用流程

1.引入依赖

<!-- easyexcel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.6</version>
        </dependency>

2.在实体类上注解

/**
     * 创建时间
     */
    @ExcelIgnore
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createdDt;

    /**
     * 创建人id
     */
    @ExcelIgnore
    @TableField(fill = FieldFill.INSERT)
    private String createBy;

    /**
     * 离职时间
     */
    @ExcelProperty(value = "离职时间",converter = LocalDateTimeConverter.class,index = 9)
    @JsonFormat(shape = JsonFormat.Shape.STRING, pattern="yyyy-MM-dd HH:mm:ss")
    private LocalDateTime outTime;

3.导出接口直接设置response传入调用的doWrite方法list类型的参数即可

@ApiOperation("EasyExcel下载")
    @PostMapping("/download")
    public void scoreEasyExcelDownload(@RequestBody EmployeeDto employeeDto,
                                       HttpServletResponse response) throws UnsupportedEncodingException {
   
        // 设置 ContentType
        response.setContentType("application/vnd.ms-excel");
        // 设置字符集
        response.setCharacterEncoding("utf-8");
        // 防止中文乱码
        String fileName = URLEncoder.encode("员工名单", "UTF-8");
        // 设置 header
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");

        try {
   
            EasyExcel.write(response.getOutputStream(), Employee.class)