当前位置：首页 > news >正文

Easypoi实现导出Excel（简单高效）

news 2025/8/18 15:08:45

今天做报表导出，网上找了很多导出的方法，最后总结发现以下方法是最简便，更易维护的导出方法，下面来分享给大家。

1、首先引入相关依赖

        <!--EasyPoi 报表--><dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-spring-boot-starter</artifactId><version>4.4.0</version></dependency>

2、导出实体映射类

@Data
public class StudentReportResponse implements Serializable {@Excel(name = "性别", width = 12)private String gender;@Excel(name = "姓名", width = 15)private String name;
}

3、Controller层代码

    @GetMapping("/exportReport")@ApiOperation("导出学生报表")public void export(ModelMap map, HttpServletResponse response, HttpServletRequest request){try {List<StudentReportResponse> studentReportData = new ArrayList<>();StudentReportResponse student = new StudentReportResponse();student.setGender("男");student.setName("测试用户");studentReportData.add(student);ExportParams params = new ExportParams("学生报表", "学生报表", ExcelType.HSSF);map.put(NormalExcelConstants.DATA_LIST, studentReportData);map.put(NormalExcelConstants.CLASS, StudentReportResponse.class);map.put(NormalExcelConstants.PARAMS, params);map.put(NormalExcelConstants.FILE_NAME, "学生报表");PoiBaseView.render(map, request, response, NormalExcelConstants.EASYPOI_EXCEL_VIEW);} catch (Exception e) {logger.error("导出学生报表报错：", e);}}

怎么样，是不是很简洁，可读性很高 ღ( ´･ᴗ･` )

查看全文

http://www.lryc.cn/news/322612.html