注解介绍

@Excels 不可单独使用，@Excels的使用均依赖于注解@Excel， 解耦合可进行读取Model的属性，作为单元格表格属性

注解使用案例

实现效果

image.png

代码详情

Model基本类

  1. package cn.zzhardy.utils.poi.test.example;
  3. import cn.zzhardy.annotation.Excel;
  4. import cn.zzhardy.annotation.Excel.FunctionType;
  5. import cn.zzhardy.annotation.Excels;
  6. import lombok.Data;
  8. @Data
  9. public class SysUser {
  10.     @Excel(name = "登录名称", sort = 1)
  11.     private String userName;
  13.     @Excel(name = "用户名称", sort = 2)
  14.     private String nickName;
  16.     @Excels({
  17.         @Excel(name = "部门名称", sort = 3, targetAttr = "deptName", type = FunctionType.EXPORT),
  18.         @Excel(name = "部门负责人", sort = 4, horizontalMergeNum = 3, targetAttr = "leader", type = FunctionType.EXPORT, titleBackground = "217,225,242")
  19.     })
  20.     private SysDept dept;
  22. }
  2. import lombok.Data;
  4. @Data
  5. public class SysDept {
  7.     /** 部门名称 */
  8.     private String deptName;
  10.     /** 负责人 */
  11.     private String leader;
  13. }

测试类

  1.     /**
  2.      * @Excels设置范例
  3.      */
  4.     @Test
  5.     public void createMoreExcels() {
  6.         List<SysUser> list    = new ArrayList<>();
  7.         SysUser       sysUser = new SysUser();
  8.         SysDept       sysDept = new SysDept();
  9.         sysDept.setDeptName("测试部门");
  10.         sysDept.setLeader("测试部门领导");
  11.         sysUser.setDept(sysDept);
  12.         sysUser.setNickName("n昵称");
  13.         sysUser.setUserName("dsds");
  14.         list.add(sysUser);
  15.         list.add(sysUser);
  16.         list.add(sysUser);
  17.         list.add(sysUser);
  18.         list.add(sysUser);
  19.         ExcelCenter<SysUser> util = new ExcelCenter<>(SysUser.class);
  20.         AjaxResult          form = util.exportExcel(list, "form");
  21.         System.out.println(form.toString());
  22.     }