Merge remote-tracking branch 'origin/glccwcs' into glccwcs

Administrator

3 天以前 aa33e56e37cd19b88ae8eea69c5ebc7c6da8b1d2

 src/main/java/com/zy/common/utils/excel/ExcelUtils.java

@@ -16,19 +16,9 @@
        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(){
    public static List<EnInitData> data() {
        List<EnInitData> list = new ArrayList<>();
        for (int i = 0; i<1000; i++) {
        for (int i = 0; i < 1000; i++) {
            EnInitData data = new EnInitData();
            data.setEnName("测试");
            data.setCode("test");
@@ -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());
    }
}