jeecg导出多个sheet Excel(干货教学)

依赖相关的请看这里

jeecg 导入多个sheet页 excel(干货教学)-优快云博客

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;
    }

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值