jeecg导出多个sheet Excel（干货教学）

原创

于 2024-09-13 11:14:40 发布 · 658 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #java #windows

依赖相关的请看这里

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