| | |
| | | */ |
| | | @GetMapping("export-security-info") |
| | | public void exportSecurityInfo(HttpServletResponse response, UserVO user) throws IOException { |
| | | List<SecurityExcel> list = userService.exportSecurityInfo(user); |
| | | List<ExportSecurityExcel> list = userService.exportSecurityInfo(user); |
| | | String fileName = null; |
| | | try { |
| | | response.setContentType("application/vnd.ms-excel"); |
| | |
| | | fileName = URLEncoder.encode("保安员数据导出" + DateUtil.time(), Charsets.UTF_8.name()); |
| | | response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); |
| | | //修改单元格格式为文本格式 |
| | | EasyExcel.write(response.getOutputStream(), SecurityExcel.class).sheet("保安员数据表").registerWriteHandler(new RowWriteHandler()).doWrite(list); |
| | | EasyExcel.write(response.getOutputStream(), ExportSecurityExcel.class).sheet("保安员数据表").registerWriteHandler(new RowWriteHandler()).doWrite(list); |
| | | } catch (Throwable var6) { |
| | | throw var6; |
| | | } |