今天做報(bào)表導(dǎo)出，網(wǎng)上找了很多導(dǎo)出的方法，最后總結(jié)發(fā)現(xiàn)以下方法是最簡(jiǎn)便，更易維護(hù)的導(dǎo)出方法，下面來分享給大家。

1、首先引入相關(guān)依賴

        <!--EasyPoi 報(bào)表--><dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-spring-boot-starter</artifactId><version>4.4.0</version></dependency>

2、導(dǎo)出實(shí)體映射類

@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("導(dǎo)出學(xué)生報(bào)表")public void export(ModelMap map, HttpServletResponse response, HttpServletRequest request){try {List<StudentReportResponse> studentReportData = new ArrayList<>();StudentReportResponse student = new StudentReportResponse();student.setGender("男");student.setName("測(cè)試用戶");studentReportData.add(student);ExportParams params = new ExportParams("學(xué)生報(bào)表", "學(xué)生報(bào)表", ExcelType.HSSF);map.put(NormalExcelConstants.DATA_LIST, studentReportData);map.put(NormalExcelConstants.CLASS, StudentReportResponse.class);map.put(NormalExcelConstants.PARAMS, params);map.put(NormalExcelConstants.FILE_NAME, "學(xué)生報(bào)表");PoiBaseView.render(map, request, response, NormalExcelConstants.EASYPOI_EXCEL_VIEW);} catch (Exception e) {logger.error("導(dǎo)出學(xué)生報(bào)表報(bào)錯(cuò)：", e);}}

怎么樣，是不是很簡(jiǎn)潔，可讀性很高 ?( ′･?･` )