zhang
2025-06-13 ae54e42cbe354ef5c39954eed2eab18de9504946
src/main/java/com/zy/common/utils/excel/ExcelUtils.java
@@ -16,16 +16,6 @@
        new ExcelUtils().simpleWrite();
    }
    public void simpleRead(){
        ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", EnInitData.class, new EnInitDataListener());
        // 读取第一个sheet(表),文件流会自动关闭
        read.sheet().doRead();
    }
    public void simpleWrite(){
        EasyExcel.write("/Users/vincent/Desktop/writeDemo.xls", EnInitData.class).sheet("lxt").doWrite(data());
    }
    public static List<EnInitData> data(){
        List<EnInitData> list = new ArrayList<>();
        for (int i = 0; i<1000; i++) {
@@ -38,4 +28,14 @@
        }
        return list;
    }
    public void simpleRead() {
        ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", EnInitData.class, new EnInitDataListener());
        // 读取第一个sheet(表),文件流会自动关闭
        read.sheet().doRead();
    }
    public void simpleWrite() {
        EasyExcel.write("/Users/vincent/Desktop/writeDemo.xls", EnInitData.class).sheet("lxt").doWrite(data());
    }
}