Easypoi导出excel

1、pom依赖

<dependency>
	<groupId>cn.afterturn</groupId>
	<artifactId>easypoi-spring-boot-starter</artifactId>
	<version>4.0.0</version>
</dependency>

2、controller代码

@ApiOperation(value = "导出讲评明细", notes = "导出讲评明细", httpMethod = "POST")
@PostMapping("/exportjpmx")
public ResponseResult<ResponseTypes> exportJcgjpmx(@RequestBody AljphdtjQueryParam queryParam,
												   HttpServletResponse response) throws IOException {
	List<AljphdtjJcgQueryReulst> QueryReulstList = aljphdtjSerivce.queryJpmx(queryParam);
	ExportParams exportParams = new ExportParams("导出讲评明细",
												 "导出讲评明细", ExcelType.XSSF);
	try(
		Workbook workbook = ExcelExportUtil.exportExcel(exportParams,
														AljphdtjJcgQueryReulst.class, jcgQueryReulstList);
		ServletOutputStream outputStream = response.getOutputStream();
	) {
		response.setContentType("application/vnd.ms-excel");
		response.setHeader("Content-Disposition", "attachment;filename=" +
						   URLEncoder.encode("导出讲评明细.xlsx", "UTF-8"));
		workbook.write(outputStream);
	} catch (Exception e) {
		throw e;
	}
	return new ResponseResult<>(ResponseTypes.SUCCESS);
}

3、实体类

package com.swx.jxkh.yjkh.aljphdtj.application.query;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

/**
 * 案例讲评活动统计查询入参
 *
 * @author codertl
 * @date 2024/03/14
 */
@Data
@ApiModel(value = "案例讲评活动统计查询入参")
public class AljphdtjJcgQueryReulst {

    @ApiModelProperty(value = "单位编码")
    private String dwbm;

    @ApiModelProperty(value = "单位名称")
    @Excel(name = "单位名称", orderNum = "0", width = 50.0)
    private String dwmc;

    @ApiModelProperty(value = "部门编码")
    private String bmbm;

    @ApiModelProperty(value = "部门名称")
    @Excel(name = "部门名称", orderNum = "1", width = 50.0)
    private String bmmc;

    @ApiModelProperty(value = "人员名称")
    @Excel(name = "人员名称", orderNum = "2", width = 50.0)
    private String rymc;

    @ApiModelProperty(value = "讲评时间")
    @Excel(name = "讲评时间", orderNum = "3", width = 50.0, format = "yyyy年MM月dd日")
    private Date jpsj;

    @ApiModelProperty(value = "组织讲评活动的单位或部门")
    @Excel(name = "组织讲评活动的单位或部门", orderNum = "4", width = 100.0)
    private String zzjphdddwhbm;

    @ApiModelProperty(value = "案例名称")
    @Excel(name = "案例名称", orderNum = "5", width = 50.0)
    private String almc;

    @ApiModelProperty(value = "案例简介")
    @Excel(name = "案例简介", orderNum = "6", width = 200.0)
    private String aljj;

    @ApiModelProperty(value = "附件路径")
    private String fjlj;
}