jeecg导出多个sheet Excel（干货教学）_jeecg导出excel-优快云博客

本文链接：https://blog.youkuaiyun.com/Cc_1208/article/details/142205541

依赖相关的请看这里

1.Controller层调用

     @RequestMapping(value = "/exportExcel")
	 public ModelAndView exportXls(Data1 data1, HttpServletRequest request) {
		 IPage<Data1> pageList = testService.page(page, queryWrapper);
		 List<Data1> list = pageList.getRecords();
		 return testService.exportExcel(request,list);
	 }

2.实现类

@Override
    public ModelAndView exportExcel(HttpServletRequest request, List<Data> list) {

        ArrayList<Data1> sheet1List = new ArrayList<>();
        ArrayList<Data2> sheet2List = new ArrayList<>();
        ArrayList<Data3> sheet3List = new ArrayList<>();
        ArrayList<Data3> sheet4List = new ArrayList<>();

        String title = "多sheet导出";
        String userName = "导出人test";
        for(Data data : list){
            //根据业务组装数据
            //此处省略组装数据
        
        }

        // 添加多个 sheet 的数据及其对应的实体类
        List<Map<String, Object>> dataList = new ArrayList<>();
        //sheet1
        Map<String, Object> map1 = new HashMap<>();
        map1.put(NormalExcelConstants.CLASS, Data1.class);
        map1.put(NormalExcelConstants.PARAMS, new ExportParams("xxx报表", "导出人:" + userName , "第一页"));
        map1.put(NormalExcelConstants.DATA_LIST, sheet1List);
        dataList.add(map1);

        //sheet2
        Map<String, Object> map2 = new HashMap<>();
        map2.put(NormalExcelConstants.CLASS, Data2.class);
        map2.put(NormalExcelConstants.PARAMS, new ExportParams("xxx报表", "导出人:" + userName ,"第二页"));
        map2.put(NormalExcelConstants.DATA_LIST, sheet2List);
        dataList.add(map2);

        //sheet3
        Map<String, Object> map3 = new HashMap<>();
        map3.put(NormalExcelConstants.CLASS, Data3.class);
        map3.put(NormalExcelConstants.PARAMS, new ExportParams("xxx报表","导出人:" + userName , "第三页"));
        map3.put(NormalExcelConstants.DATA_LIST, sheet3List);
        dataList.add(map3);

        //sheet4
        Map<String, Object> map4 = new HashMap<>();
        map4.put(NormalExcelConstants.CLASS, Data4.class);
        map4.put(NormalExcelConstants.PARAMS, new ExportParams("xxx报表", "导出人:" + userName ,"第四页"));
        map4.put(NormalExcelConstants.DATA_LIST, sheet4List);
        dataList.add(map4);

        ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
        mv.addObject(NormalExcelConstants.FILE_NAME, title);
        mv.addObject(NormalExcelConstants.MAP_LIST, dataList);
        return mv;
    }

如果此文章帮助到了你，请动动您发财的小手点点赞！