MyExcel，是一个集导入、导出、加密 Excel 等多项功能的 Java 工具包。

MyExcel 采用声明式语法来构建、读取 Excel，屏蔽 POI 的具体操作细节（对 POI 无感知），以开发常用的技术替代，使得构建（从简单到高度复杂 Excel）以及读取 Excel 变得极为便利，且构建、读取性能极为优异，占用内存极低。

如导入：

List<ArtCrowd> result = SaxExcelReader.of(ArtCrowd.class)
        .sheet(0) // 0代表第一个sheet，如果为0，可省略该操作，也可sheet("名称")读取
        .rowFilter(row -> row.getRowNum() > 0) // 如无需过滤，可省略该操作，0代表第一行
        .detectedMerge() // 识别合并单元格并填充数据，默认不识别
        .read(path);

本次更新如下：

• 修复DefaultExcelBuilder调用hideColumns无效问题；
• SaxExcelReader支持一对多导入；
• 调整DefaultStreamExcelBuilder等待队列长度，提升导出性能；
• 升级imageio-jpeg版本为3.8.2；

一对多导入示例

示例1

URL htmlToExcelEampleURL = this.getClass().getResource("/muilt_read.xlsx");
Path path = Paths.get(htmlToExcelEampleURL.toURI());

List<Grade> multiParents = SaxExcelReader.of(Grade.class)
        .rowFilter(row -> row.getRowNum() > 0)
        .detectedMerge() // 必须要调用识别合并单元格方法，否则无效
        .read(Files.newInputStream(path));

public class Grade {
    @ExcelColumn(index=0)
    private String gradeName;

    @MultiColumn(classType=String.class)
    @ExcelColumn(index=1)
    private List<String> studentNames;

    @MultiColumn(classType=Integer.class)
    @ExcelColumn(index=2)
    private List<Integer> studentAges;
}

示例2

URL htmlToExcelEampleURL = this.getClass().getResource("/muilt_read.xlsx");
Path path = Paths.get(htmlToExcelEampleURL.toURI());

List<Grade> multiParents = SaxExcelReader.of(Grade.class)
        .rowFilter(row -> row.getRowNum() > 0)
        .detectedMerge() // 必须要调用识别合并单元格方法，否则无效
        .read(Files.newInputStream(path));

public class Grade {
    @ExcelColumn(index=0)
    private String gradeName;

    @MultiColumn(classType=Student.class)
    private List<Student> students;
}

public class Student {
   @ExcelColumn(index=1)
   private String name;

   @ExcelColumn(index=2)
   private Integer age;
}

示例3

URL htmlToExcelEampleURL = this.getClass().getResource("/muilt_read.xlsx");
Path path = Paths.get(htmlToExcelEampleURL.toURI());

List<School> multiParents = SaxExcelReader.of(School.class)
        .rowFilter(row -> row.getRowNum() > 0)
        .detectedMerge() // 必须要调用识别合并单元格方法，否则无效
        .read(Files.newInputStream(path));

public class School {
    @ExcelColumn(index=0)
    private String name;

    @MultiColumn(classType=Grade.class)
    private List<Grade> grades;
}

public class Grade {
    @ExcelColumn(index=1)
    private String gradeName;

    @MultiColumn(classType=Student.class)
    private List<Student> students;
}

public class Student {
   @ExcelColumn(index=2)
   private String name;

   @ExcelColumn(index=3)
   private Integer age;
}

具体，请移步文档：https://github.com/liaochong/myexcel/wiki