| | |
|---|
| | | // ExcelUtil.export(response, "用户数据" + DateUtil.time(), "用户数据表", list, UserExcel.class); |
|---|
| | | // } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 导出保安员证信息 |
|---|
| | | */ |
|---|
| | | @GetMapping("export-security-paper") |
|---|
| | | public void exportSecurityPaper(UserVO user, HttpServletResponse response) throws IOException { |
|---|
| | | //按条件查询成绩数据 |
|---|
| | | List<ExportSecurityPaperExcel> excels = userService.exportSecurityPaperList(user); |
|---|
| | | String fileName = null; |
|---|
| | | try { |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setCharacterEncoding(org.apache.commons.codec.Charsets.UTF_8.name()); |
|---|
| | | fileName = URLEncoder.encode("保安员证数据", Charsets.UTF_8.name()); |
|---|
| | | response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); |
|---|
| | | //修改单元格格式为文本格式 |
|---|
| | | EasyExcel.write(response.getOutputStream(), ExportSecurityPaperExcel.class) |
|---|
| | | .sheet("保安员证数据表") |
|---|
| | | //自定义行高 |
|---|
| | | // .registerWriteHandler(new CustomCellWriteHeightConfig()) |
|---|
| | | //自定义宽度 |
|---|
| | | // .registerWriteHandler(new CustomCellWriteWeightConfig()) |
|---|
| | | //写入 |
|---|
| | | .doWrite(excels); |
|---|
| | | } catch (Throwable var6) { |
|---|
| | | throw var6; |
|---|
| | | } |
|---|
| | | // ExcelUtil.export(response, "保安员证数据" + DateUtil.time(), "保安员证数据表", excels, ExportSecurityPaperExcel.class); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 导出模板 |
|---|
