對這文章發表回應

    com.alibaba
    easyexcel
    {latestVersion}

@Data
public class User extends BaseRowModel {
    @ExcelProperty(value = "姓名", index = 0)
    private String name;
    @ExcelProperty(value = "暱稱", index = 1)
    private String nickName;
    @ExcelProperty(value = "密碼", index = 2)
    private String password;
    @ExcelProperty(value = "生日", index = 3, format = "yyyy/MM/dd")
    private Date birthday;
}

/**
 * @author WuShukai
 * @version V1.0
 * @description 處理Excel，將讀取到數據保存為對象並輸出
 * @date 2018/11/6  16:44
 */
public class ExcelListener extends AnalysisEventListener {
    /**
     * 自定義用於暫時存儲data。
     * 可以通過實例獲取該值
     */
    private final List data = new ArrayList<>();
    @Override
    public void invoke(T object, AnalysisContext context) {
        //數據存儲
        data.add(object);
    }
    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {
    }
    public List getData() {
        return data;
    }
}

    /**
    * 從Excel中讀取文件，讀取的文件是一個DTO類，該類必須繼承BaseRowModel
    * 具體實例參考 ： MemberMarketDto.java
    * 參考：https://github.com/alibaba/easyexcel
    * 字符流必須支持標記，FileInputStream 不支持標記，可以使用BufferedInputStream 代替
    * BufferedInputStream bis = new BufferedInputStream(new FileInputStream(...));
    *
    * @param inputStream 文件輸入流
    * @param clazz       繼承該類必須繼承BaseRowModel的類
    * @return 讀取完成的list
    */
    public static  List readExcel(final InputStream inputStream, final Class clazz) {
        if (null == inputStream) {
            throw new NullPointerException("the inputStream is null!");
        }
        AnalysisEventListener listener = new ExcelListener();
        //讀取xls 和 xlxs格式
        //如果POI版本為3.17，可以如下聲明
        ExcelReader reader = new ExcelReader(inputStream, null, listener);
        //判斷格式，針對POI版本低於3.17
        //ExcelTypeEnum excelTypeEnum = valueOf(inputStream);
        //ExcelReader reader = new ExcelReader(inputStream, excelTypeEnum, null, listener);
        reader.read(new com.alibaba.excel.metadata.Sheet(1, 1, clazz));
        return ((ExcelListener) listener).getData();
	}
    /**
    * 需要寫入的Excel，有模型映射關係
    *
    * @param file  需要寫入的Excel，格式為xlsx
    * @param list 寫入Excel中的所有數據，繼承於BaseRowModel
    */
    public static void writeExcel(final File file, List list) {
        OutputStream out = new FileOutputStream(file);
        try {
            ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLSX);
            //寫第一個sheet,  有模型映射關係
            Class t = list.get(0).getClass();
            com.alibaba.excel.metadata.Sheet sheet = new com.alibaba.excel.metadata.Sheet(1, 0, t);
            writer.write(list, sheet);
            writer.finish();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                out.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
    /**
    * 根據輸入流，判斷為xls還是xlsx，該方法原本存在於easyexcel 1.1.0 的ExcelTypeEnum中。
    * 如果POI版本為3.17以下，則FileMagic會報錯，找不到該類，此時去到POI 3.17中將FileMagic抽取出來
    */
    public static ExcelTypeEnum valueOf(InputStream inputStream) {
        try {
            FileMagic fileMagic = FileMagic.valueOf(inputStream);
            if (FileMagic.OLE2.equals(fileMagic)) {
                return ExcelTypeEnum.XLS;
            }
            if (FileMagic.OOXML.equals(fileMagic)) {
                return ExcelTypeEnum.XLSX;
            }
            throw new IllegalArgumentException("excelTypeEnum can not null");
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

ExcelReader reader = new ExcelReader(inputStream, ExcelTypeEnum.XLSX, null, new AnalysisEventListener>() {...});

/**
 * @author WuShukai
 * @version V1.0
 * @description 判斷格式，這個枚舉存在於poi 3.17，但是目前版本是3.15，所以從3.17抽出來使用
 * @date 2018/11/6  16:46
 */
public enum FileMagic {
    /**
     * OLE2 / BIFF8+ stream used for Office 97 and higher documents
     */
    OLE2(HeaderBlockConstants._signature),
    /**
     * OOXML / ZIP stream
     */
    OOXML(org.apache.poi.poifs.common.POIFSConstants.OOXML_FILE_HEADER),
    /**
     * UNKNOWN magic
     */
    UNKNOWN(new byte[0]);
    final byte[][] magic;
    FileMagic(long magic) {
        this.magic = new byte[1][8];
        LittleEndian.putLong(this.magic[0], 0, magic);
    }
    FileMagic(byte[]... magic) {
        this.magic = magic;
    }
    public static FileMagic valueOf(byte[] magic) {
        for (FileMagic fm : values()) {
            int i = 0;
            boolean found = true;
            for (byte[] ma : fm.magic) {
                for (byte m : ma) {
                    byte d = magic[i++];
                    if (!(d == m || (m == 0x70 && (d == 0x10 || d == 0x20 || d == 0x40)))) {
                        found = false;
                        break;
                    }
                }
                if (found) {
                    return fm;
                }
            }
        }
        return UNKNOWN;
    }
    /**
     * @param inp An InputStream which supports either mark/reset
     */
    public static FileMagic valueOf(InputStream inp) throws IOException {
        if (!inp.markSupported()) {
            throw new IOException("getFileMagic() only operates on streams which support mark(int)");
        }
        // Grab the first 8 bytes
        byte[] data = IOUtils.peekFirst8Bytes(inp);
        return FileMagic.valueOf(data);
    }
}

try(BufferedInputStream bis = new BufferedInputStream(new FileInputStream(file))) {
    do something...
}