| | |
| | | public void exportSecurity(HttpServletResponse response) throws IOException { |
| | | List<SecurityPaperExcel> list = new ArrayList<>(); |
| | | SecurityPaperExcel securityExcel = new SecurityPaperExcel(); |
| | | securityExcel.setDeptId("xxx保安公司"); |
| | | securityExcel.setId("12124121245121"); |
| | | securityExcel.setRealName("张三"); |
| | | securityExcel.setPhone("12345678901"); |
| | | securityExcel.setCardid("360XXX19XXXXXX****"); |
| | | securityExcel.setRegistered("江西省南昌市******"); |
| | | // securityExcel.setPhone("12345678901"); |
| | | // securityExcel.setCardid("360XXX19XXXXXX****"); |
| | | // securityExcel.setRegistered("江西省南昌市******"); |
| | | list.add(securityExcel); |
| | | |
| | | SecurityPaperExcel securityExcel1 = new SecurityPaperExcel(); |
| | | securityExcel1.setDeptId("xxx保安公司"); |
| | | securityExcel.setId("12124121245121"); |
| | | securityExcel1.setRealName("李四"); |
| | | securityExcel1.setPhone("12345678901"); |
| | | securityExcel1.setCardid("360XXX19XXXXXX****"); |
| | | securityExcel1.setRegistered("江西省南昌市******"); |
| | | // securityExcel1.setPhone("12345678901"); |
| | | // securityExcel1.setCardid("360XXX19XXXXXX****"); |
| | | // securityExcel1.setRegistered("江西省南昌市******"); |
| | | list.add(securityExcel1); |
| | | String fileName = null; |
| | | try { |
| | |
| | | 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(), SecurityPaperExcel.class).sheet("保安员数据表").registerWriteHandler(new RowWriteHandler()).doWrite(list); |
| | | } catch (Throwable var6) { |
| | | throw var6; |
| | | } |