依赖相关的请看这里
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;
}
如果此文章帮助到了你,请动动您发财的小手点点赞!