Excel4J 是基于Excel模板导入导出

    // 学号
    @ExcelField(title = "学号", order = 1)
    private String id;

    // 姓名
    @ExcelField(title = "姓名", order = 2)
    private String name;

    // 班级
    @ExcelField(title = "班级", order = 3)
    private String classes;

  @Test
  public void excel2Object() {
      String path = "D:\\JProject\\Excel4J\\src\\test\\java\\resource\\student.xlsx";

      System.out.println("读取全部：");
      List<Student> students = ExcelUtil.getInstance().readExcel2ObjsByClasspath(path, Student.class);
      for (Student stu : students) {
          System.out.println(stu.getName() + " -- " + stu.getClasses());
      }

      System.out.println("读取指定行数：");
      students = ExcelUtil.getInstance().readExcel2ObjsByClasspath(path, Student.class, 0, 2);
      for (Student stu : students) {
          System.out.println(stu.getName() + " -- " + stu.getClasses());
      }
  }

 @Test
 public void object2Excel(){
     String tempPath = "D:\\IdeaSpace\\Excel4J\\src\\test\\java\\resource\\template.xlsx";
     List<Student> list = new ArrayList<>();
     list.add(new Student("1010001", "盖伦", "六年级三班"));
     list.add(new Student("1010002", "古尔丹", "一年级三班"));
     list.add(new Student("1010003", "蒙多", "六年级一班"));
     list.add(new Student("1010004", "萝卜特", "三年级二班"));
     Map<String, String> datas = new HashMap<>();
     datas.put("title", "战争学院花名册");
     datas.put("info", "学校统一花名册");
     ExcelUtil.getInstance().exportObj2ExcelByTemplate(datas, tempPath, "D:\\2.xlsx", list, Student.class, false, true);
 }