Java导出excel表

1public ModelAndView exportXls(HttpServletRequest request, MeetingEnter meetingEnter,String meetingId) {//导出相同会议下的报名名单
2      Map<String, String[]> parameterMap = request.getParameterMap();
3      Map<String, String[]> map = new HashMap<>();
4      List<MeetingEnter> meetingEnterList= meetingEnterService.selectByMeetingId(meetingId);
5      Iterator<Map.Entry<String, String[]>> iterator = map.entrySet().iterator();
6      while (iterator.hasNext()){
7          Map.Entry<String, String[]> next = iterator.next();
8          String key = next.getKey();
9          next.setValue(meetingEnterList.toArray(new String[]{}));
10          if (key!=null&&map.get(key)!=null){
11              parameterMap.put(key.toString(),map.get(key));
12          }
13      }
14      return super.exportXls(request,meetingEnter,MeetingEnter.class, "会议报名管理");
15  }
16
17protected ModelAndView exportXls(HttpServletRequest request, T object, Class<T> clazz, String title) {
18        // Step.1 组装查询条件
19        QueryWrapper<T> queryWrapper = QueryGenerator.initQueryWrapper(object, request.getParameterMap());
20        LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();
21
22        // Step.2 获取导出数据
23        List<T> pageList = service.list(queryWrapper);
24        List<T> exportList = null;
25
26        // 过滤选中数据
27        String selections = request.getParameter("selections");
28        if (oConvertUtils.isNotEmpty(selections)) {
29            List<String> selectionList = Arrays.asList(selections.split(","));
30            exportList = pageList.stream().filter(item -> selectionList.contains(getId(item))).collect(Collectors.toList());
31        } else {
32            exportList = pageList;
33        }
34
35        // Step.3 AutoPoi 导出Excel
36        ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
37        mv.addObject(NormalExcelConstants.FILE_NAME, title); //此处设置的filename无效 ,前端会重更新设置一下
38        mv.addObject(NormalExcelConstants.CLASS, clazz);
39        mv.addObject(NormalExcelConstants.PARAMS, new ExportParams(title + "报表", "导出人:" + sysUser.getRealname(), title));
40        mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
41        return mv;
42    }