easy poi 导出功能（表格一对多）

最近在导出功能，查到easypoi 做个简单的工具类，希望帮助到您，自己做下收藏！

pom.xml 文件

    <dependency>
	        <groupId>cn.afterturn</groupId>
	        <artifactId>easypoi-base</artifactId>
	        <version>3.2.0</version>
	</dependency>
	<dependency>
	        <groupId>cn.afterturn</groupId>
	        <artifactId>easypoi-web</artifactId>
	        <version>3.2.0</version>
	</dependency>
	<dependency>
	       <groupId>cn.afterturn</groupId>
	       <artifactId>easypoi-annotation</artifactId>
	       <version>3.2.0</version>
	</dependency>

1、创建部门实体

注：@Datee 注解用是到lombok插件

@Data
@ExcelTarget("empUtil")	
public class DeptUtil {@Excel(name = "部门编号", width = 30 , needMerge = true)
private Integer id;

@Excel(name = "部门名称", width = 30 , needMerge = true)
private String deptName;

@ExcelCollection(name = "员工信息")
private List<EmpUtil> emps;

}

2、创建员工实体

@Data
@ExcelTarget("empUtil")
public class EmpUtil {

@Excel(name = "序号", width = 30, isColumnHidden = true)
private Integer id;

@Excel(name = "员工姓名", width = 30, groupName = "基本信息")
private String empName;

@Excel(name = "年龄", width = 30, type = 10, groupName = "基本信息")
private Integer age;

@Excel(name = "入职时间", width = 30, groupName = "工作信息", format = "yyyy/MM/dd HH:mm")
private Date hiredate;

@Excel(name = "薪酬", width = 30, type = 10, groupName = "工作信息")
private BigDecimal salary;

}

3、demo方法

注：demo中写的一些测试数据，根据自身业务的情况进行简单封装。

@GetMapping("export")
public void export(QueryRequest queryRequest, FilingRecord filingRecord, HttpServletResponse response)
		throws FebsException {
	try {
		// 设置响应输出的头类型
		response.setHeader("content-Type", "application/vnd.ms-excel");
		// 下载文件的默认名称
		response.setHeader("Content-Disposition", "attachment;filename=user.xls");
		// =========easypoi部分
		List<DeptUtil> exportList = new LinkedList<DeptUtil>();
		DeptUtil deptUtil = new DeptUtil();
		deptUtil.setId(1);
		deptUtil.setDeptName("研发部");
		
		List<EmpUtil> ll = new LinkedList<EmpUtil>();
		EmpUtil empUtil = new EmpUtil();
		empUtil.setId(1);
		empUtil.setAge(20);
		empUtil.setEmpName("研发");
		empUtil.setHiredate(new Date());
		
		EmpUtil empUtil2 = new EmpUtil();
		empUtil2.setId(1);
		empUtil2.setAge(20);
		empUtil2.setEmpName("测试");
		empUtil2.setHiredate(new Date());
		ll.add(empUtil);
		ll.add(empUtil2);
		deptUtil.setEmps(ll);
		exportList.add(deptUtil);
		ExportParams deptExportParams = new ExportParams();
		// 设置sheet得名称
		deptExportParams.setSheetName("员工报表1");
		
		Map<String, Object> deptExportMap = new HashMap<>();
		// title的参数为ExportParams类型，目前仅仅在ExportParams中设置了sheetName
		deptExportMap.put("title", deptExportParams);
		// 模版导出对应得实体类型
		deptExportMap.put("entity", DeptUtil.class);
		// sheet中要填充得数据
		deptExportMap.put("data", exportList);
		
		List<Map<String, Object>> sheetsList = new ArrayList<>();
		sheetsList.add(deptExportMap);
		Workbook workbook =ExcelExportUtil.exportExcel(sheetsList, ExcelType.HSSF);
		ServletOutputStream outputStream = response.getOutputStream();
		workbook.write(outputStream);
		outputStream.flush();
		outputStream.close();
	} catch (Exception e) {
		log.error(e.getMessage(), e);
	}
}

4、导出结果

5、如果员工实体下再有个List
在员工实体类中注解增加
@ExcelCollection(name = “角色信息”)
private List roles;

原文链接：https://blog.csdn.net/qq_31984879/article/details/102715335