EasyPOI简单导入Excel示例

1、添加依赖

<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-base</artifactId>
    <version>4.1.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-web</artifactId>
    <version>4.1.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-annotation</artifactId>
    <version>4.1.0</version>
</dependency>

2、实体创建

?

1 2 3 4 5 6 7 8 9

@Data public class ReportModel implements Serializable {       @Excel(name = "报案号",orderNum = "0")     private String reportNo;       @Excel(name = "单号",orderNum = "1")     private String bizOrderNo; }

3、Excel示例

 

 4、示例代码

?

1 2 3 4 5 6 7 8 9 10

@Test public void testFileParse() throws Exception {       ImportParams params = new ImportParams();     params.setTitleRows(0);//示例Excel中没有标题 故此设置titlsRows为0     params.setHeadRows(1); //示例Excel中表头在第一行 所以设置headRows为1     FileInputStream inputStream = new FileInputStream(new File("test.xlsx"));     List<ReportModel> list = ExcelImportUtil.importExcel(inputStream, ReportModel.class, params);     System.out.println(list.size()); }