MyExcel 4.3.0.RC 发布，支持一对多导入

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