<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>4.0.3</version> <!-- 請(qǐng)使用最新版本 -->
</dependency>

import com.alibaba.excel.EasyExcel;
 
import java.util.ArrayList;
import java.util.List;
 
public class EasyExcelWriteExample {
 
    public static void main(String[] args) {
        String fileName = "example.xlsx";
 
        // 準(zhǔn)備數(shù)據(jù)
        List<UserData> data = generateData();
 
        // 寫(xiě)入文件
        EasyExcel.write(fileName, UserData.class)
                .sheet("用戶(hù)信息")
                .doWrite(data);
    }
 
    private static List<UserData> generateData() {
        List<UserData> list = new ArrayList<>();
        for (int i = 1; i <= 10; i++) {
            list.add(new UserData(i, "用戶(hù)" + i, "user" + i + "@example.com"));
        }
        return list;
    }
 
    // 數(shù)據(jù)類(lèi)，使用注解指定表頭
    public static class UserData {
        @com.alibaba.excel.annotation.ExcelProperty("用戶(hù)ID")
        private Integer id;
 
        @com.alibaba.excel.annotation.ExcelProperty("用戶(hù)名")
        private String name;
 
        @com.alibaba.excel.annotation.ExcelProperty("郵箱")
        private String email;
 
        // 構(gòu)造函數(shù)、Getter 和 Setter
        public UserData(Integer id, String name, String email) {
            this.id = id;
            this.name = name;
            this.email = email;
        }
    }
}

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.read.listener.ReadListener;
 
import java.util.List;
 
public class EasyExcelReadExample {
 
    public static void main(String[] args) {
        String fileName = "example.xlsx";
 
        // 讀取文件
        EasyExcel.read(fileName, UserData.class, new UserDataListener())
                .sheet()
                .doRead();
    }
 
    // 自定義監(jiān)聽(tīng)器，處理每一行數(shù)據(jù)
    public static class UserDataListener implements ReadListener<UserData> {
        @Override
        public void invoke(UserData data, AnalysisContext context) {
            System.out.println("讀取到數(shù)據(jù)：" + data);
        }
 
        @Override
        public void doAfterAllAnalysed(AnalysisContext context) {
            System.out.println("所有數(shù)據(jù)讀取完畢");
        }
    }
}

public class MultiLevelData {
    @com.alibaba.excel.annotation.ExcelProperty({"用戶(hù)信息", "用戶(hù)ID"})
    private Integer id;
 
    @com.alibaba.excel.annotation.ExcelProperty({"用戶(hù)信息", "用戶(hù)名"})
    private String name;
 
    @com.alibaba.excel.annotation.ExcelProperty({"聯(lián)系方式", "郵箱"})
    private String email;
}

EasyExcel.read(fileName, UserData.class, new ReadListener<UserData>() {
    @Override
    public void invoke(UserData data, AnalysisContext context) {
        // 處理每一條數(shù)據(jù)
    }
 
    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {
        // 處理完成后執(zhí)行
    }
}).sheet().doRead();