一、使用EasyExcel 读取excel数据并转换成对象
1、使用的maven依赖及版本:
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-scratchpad</artifactId>
<version>3.17</version>
</dependency>
2、代码如下:将用到三个类,MyExcelListener.java,StudentInfo.java,ExcelUtil.java
StudentInfo.java
@Getter
@Setter
public class StudentInfo implements Serializable {
private static final long serialVersionUID = 7566235228027597205L;
private String studnetName;
private String gender;
private String classes;
private double score;
}
ExcelListener.j