| | |
| | | InputStream inputStream = null; |
| | | try { |
| | | List<List<String>> list = new ArrayList<>(); |
| | | list = dataFilling(); |
| | | list = headDataFilling(); |
| | | List<List<Object>> dataList = new ArrayList<>(); |
| | | List<Object> data = new ArrayList<>(); |
| | | data = formDataFilling(); |
| | | |
| | | //查询当前社区标签列表 |
| | | R tagsResult = userService.listTags(communityId); |
| | | if(Constants.SUCCESS.equals(tagsResult.getCode())){ |
| | |
| | | List<String> head = new ArrayList<>(); |
| | | head.add(TagsList.get(i) + "(是/否)"); |
| | | list.add(head); |
| | | data.add("否"); |
| | | } |
| | | } |
| | | List<List<Object>> dataList = new ArrayList<>(); |
| | | List<Object> data = new ArrayList<>(); |
| | | data.add("张三"); |
| | | data.add("男"); |
| | | data.add(25); |
| | | data.add("是"); |
| | | data.add("樱花街"); |
| | | data.add(115); |
| | | data.add("15栋"); |
| | | data.add(10); |
| | | data.add(1001); |
| | | data.add("汉族"); |
| | | data.add("群众"); |
| | | data.add("513421199508187219"); |
| | | data.add("13768548521"); |
| | | data.add("中国"); |
| | | data.add("阿里巴巴"); |
| | | dataList.add(data); |
| | | |
| | | EasyExcel.write(fileName).head(list).sheet("实有人口导入模板").doWrite(dataList); |
| | | |
| | | File file = new File(fileName); |
| | |
| | | return communityService.deletePopulations(Ids); |
| | | } |
| | | |
| | | private List<List<String>> dataFilling(){ |
| | | private List<List<String>> headDataFilling(){ |
| | | List<List<String>> list = new ArrayList<List<String>>(); |
| | | List<String> head0 = new ArrayList<String>(); |
| | | head0.add("家庭成员"); |
| | |
| | | List<String> head10 = new ArrayList<String>(); |
| | | head10.add("民族"); |
| | | List<String> head11 = new ArrayList<String>(); |
| | | head11.add("政治面貌"); |
| | | head11.add("政治面貌(群众/中共党员/共青团员)"); |
| | | List<String> head12 = new ArrayList<String>(); |
| | | head12.add("身份证"); |
| | | List<String> head13 = new ArrayList<String>(); |
| | |
| | | list.add(head15); |
| | | return list; |
| | | } |
| | | |
| | | private List<Object> formDataFilling(){ |
| | | List<Object> data = new ArrayList<>(); |
| | | data.add("张三"); |
| | | data.add("男"); |
| | | data.add(25); |
| | | data.add("是"); |
| | | data.add("樱花街"); |
| | | data.add(115); |
| | | data.add("15栋"); |
| | | data.add(10); |
| | | data.add(1001); |
| | | data.add("汉族"); |
| | | data.add("群众"); |
| | | data.add("513421199508187219"); |
| | | data.add("13768548521"); |
| | | data.add("中国"); |
| | | data.add("阿里巴巴"); |
| | | return data; |
| | | } |
| | | } |