@PostMapping("/export")
public void export(@RequestBody PassRecordFindAllVm model, HttpServletResponse response) throws Exception {
List<PassRecordEntity> allList = passRecordService.exportAll(model);
String[][] strArray = allList.stream().map(x -> {
String[] str = new String[9];
str[0] = x.getUserName();
str[1] = x.getDepartmentName();
str[2] = x.getCharacteristic();
str[3] = x.getDeviceName();
str[4] = x.getDevicePosition();
str[5] = x.getWayOfAccess();
str[6] = x.getStatus();
str[7] = x.getTransitTime();
return str;
}).toArray(String[][]::new);
String[] headers = {"人员姓名", "部门", "特征", "门禁名称", "设备位置","通行方式","验证结果","通行时间"};
ExcelUtil excelUtil = new ExcelUtil();
excelUtil.exporteExcel("通行记录", headers, strArray, response);
}
List集合导出EXCEL表
最新推荐文章于 2023-11-09 15:47:35 发布