POM依賴

<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>easyexcel</artifactId>
	<version>3.1.0</version>
</dependency>

根據(jù)讀取的Excel文件創(chuàng)建實(shí)體類

我這里在D盤目錄下創(chuàng)建一個(gè)test.xlsx文件，文件中是這樣的數(shù)據(jù)列與數(shù)據(jù)行：

在項(xiàng)目中創(chuàng)建實(shí)體類，根據(jù)Excel文件的表頭創(chuàng)建對(duì)應(yīng)的實(shí)體類：

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

@NoArgsConstructor
@AllArgsConstructor
@Data
@Builder
public class TestExcel {

    // value 是excel文件的表頭   index 是第幾列
    @ExcelProperty(value = "用戶名", index = 0)
    private String name;

    @ExcelProperty(value = "年齡", index = 1)
    private String age;

    @ExcelProperty(value = "性別", index = 2)
    private String gender;

    @ExcelProperty(value = "出生年月日", index = 3)
    private Date birthday;

}

讀取Excel文件數(shù)據(jù)

    public static void main(String[] args) {
        // 讀取文件的路徑
        final String excelFilePath = "D:/test.xlsx";

        // 讀取excel
        EasyExcel.read(excelFilePath, TestExcel.class, new AnalysisEventListener<TestExcel>() {
            // 每讀取一行數(shù)據(jù), 該方法會(huì)被調(diào)用一次
            @Override
            public void invoke(TestExcel testExcel, AnalysisContext analysisContext) {
                System.out.println("讀取了一行");
                System.out.println("testExcel " + testExcel);
            }

            // 全部讀取完成被調(diào)用
            @Override
            public void doAfterAllAnalysed(AnalysisContext analysisContext) {
                System.out.println("全部讀取完成");
            }
        }).sheet().doRead();
    }

打印日志：

讀取了一行
testExcel TestExcel(name=張三, age=19, gender=男, birthday=Tue Jan 01 00:00:00 CST 2002)
讀取了一行
testExcel TestExcel(name=李四, age=20, gender=女, birthday=Fri Feb 02 00:00:00 CST 2001)
全部讀取完成