jeecgboot AutoPOI（Excel工具）导出方式总结

客官°小女子只卖身不卖艺 2022-12-31 13:18 1003阅读 0赞

### 文章目录 ###

*  1：导出Map
 *  2：使用代码
 *  3：重要代码

> 模式一：map数据，手动封装ExcelExportEntity集合

# 1：导出Map #

> 创建类似注解的集合,即可完成Map的导出,略有麻烦

List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
    	entity.add(new ExcelExportEntity("姓名", "name"));
    	entity.add(new ExcelExportEntity("性别", "sex"));
    
    	List<Map<String, String>> list = new ArrayList<Map<String, String>>();
    	Map<String, String> map;
    	for (int i = 0; i < 10; i++) { 
    		map = new HashMap<String, String>();
    		map.put("name", "1" + i);
    		map.put("sex", "2" + i);
    		list.add(map);
    	}
    
    	HSSFWorkbook workbook = ExcelExportUtil.exportExcel(new ExportParams(
    			"测试", "测试"), entity, list);

# 2：使用代码 #

LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
            //制作表头
            List<ExcelExportEntity> entityList = new ArrayList<>();
            ExcelExportEntity entity = new ExcelExportEntity("账号", "username");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("姓名", "realname");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("工号", "workNo");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("坐席号", "seatNo");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("分机号", "extension");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("分机号", "username");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("部门", "orgCode");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("负责部门", "departIds");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("角色", "roleNames");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("职务", "post");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("最后登录时间", "lastLoginTime");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("状态", "status");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("生日", "birthday");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("性别", "sex");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("邮箱", "email");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("手机号码", "phone");
            entity.setWidth(15);
            entityList.add(entity);
            entity = new ExcelExportEntity("座机", "telephone");
            entity.setWidth(15);
            entityList.add(entity);
            // Step.1 组装查询条件
            QueryWrapper<SysUser> queryWrapper = QueryGenerator.initQueryWrapper(sysUser, request.getParameterMap());
            //Step.2 AutoPoi 导出Excel
            ModelAndView mv = new ModelAndView(new JeecgMapExcelView());
            //update-begin--Author:kangxiaolin  Date:20180825 for：[03]用户导出，如果选择数据则只导出相关数据--------------------
            String selections = request.getParameter("selections");
            if (!oConvertUtils.isEmpty(selections)) { 
                queryWrapper.in("id", selections.split(","));
            }
            List<Map<String,Object>>  dataList = sysUserService.listMaps(queryWrapper);
            //导出文件名称
            mv.addObject(NormalExcelConstants.FILE_NAME, "用户列表");
            mv.addObject(MapExcelConstants.ENTITY_LIST, entityList);
            mv.addObject(NormalExcelConstants.PARAMS,new ExportParams("人员列表数据", "导出人:" + user.getRealname(), "人员导出信息"));
            mv.addObject(NormalExcelConstants.MAP_LIST, dataList);
            return mv;

# 3：重要代码 #

1.  制作表头（配置ExcelExportEntity集合如下）

List<ExcelExportEntity> entityList = new ArrayList<>();
    //一般表头使用这种两个参数的构造器
    ExcelExportEntity e1 = new ExcelExportEntity("姓名","name");
    ExcelExportEntity e2 = new ExcelExportEntity("年龄","age");
    ExcelExportEntity e3 = new ExcelExportEntity("体温","degree");
    entityList.add(e1);
    entityList.add(e2);
    entityList.add(e3);
    //需要被设置成子表头的使用这种三个参数的构造器,设置colspan为true
    ExcelExportEntity e5 = new ExcelExportEntity("姓名","link_name",true);
    ExcelExportEntity e6 = new ExcelExportEntity("年龄","link_age", true);
    entityList.add(e5);
    entityList.add(e6);
    //合并表头也需要设置colspan为true
    ExcelExportEntity e4 = new ExcelExportEntity("紧急联系人","linkman",true);
    List<String> sub = new ArrayList<>();
    sub.add("link_name");
    sub.add("link_age");
    //还需要设置一个子表头key的集合
    e4.setSubColumnList(sub);
    entityList.add(e4);

1.  数据格式如下：

List<Map<String,Object>> dataList = new ArrayList<Map<String,Object>>();
    Map<String,Object> map1 = new HashMap<>();
    map1.put("name","小明");
    map1.put("age","21");
    map1.put("degree","36");
    map1.put("link_name","小八");
    map1.put("link_age","33");
    dataList.add(map1);
    
    Map<String,Object> map2 = new HashMap<>();
    map2.put("name","小王");
    map2.put("age","24");
    map2.put("degree","37");
    map2.put("link_name","小六");
    map2.put("link_age","26");
    dataList.add(map2);

1.  模型视图修改为Map

ModelAndView mv = new ModelAndView(new JeecgMapExcelView());

1.  数据格式改为Map

mv.addObject(MapExcelConstants.ENTITY_LIST, entityList);

1.  数据接收形式也改为Map

mv.addObject(NormalExcelConstants.MAP_LIST, dataList);