資源簡介
Java解析、生成Excel比較有名的框架有Apache poi、jxl。但他們都存在一個嚴重的問題就是非常的耗內存，poi有一套SAX模式的API可以一定程度的解決一些內存溢出的問題，但POI還是有一些缺陷，比如07版Excel解壓縮以及解壓后存儲都是在內存中完成的，內存消耗依然很大。easyexcel重寫了poi對07版Excel的解析，能夠原本一個3M的excel用POI sax依然需要100M左右內存降低到KB級別，并且再大的excel不會出現內存溢出，03版依賴POI的sax模式。在上層做了模型轉換的封裝，讓使用者更加簡單方便
代碼片段和文件信息
package?com.alibaba.excel;
import?com.alibaba.excel.context.AnalysisContext;
import?com.alibaba.excel.event.AnalysisEventListener;
import?com.alibaba.excel.event.WriteHandler;
import?com.alibaba.excel.metadata.Sheet;
import?com.alibaba.excel.support.ExcelTypeEnum;
import?java.io.InputStream;
import?java.io.OutputStream;
import?java.util.ArrayList;
import?java.util.List;
/**
?*?Reader?and?writer?factory?class
?*
?*?@author?jipengfei
?*/
public?class?EasyExcelFactory?{
????/**
?????*?Quickly?read?small?files，no?more?than?10000?lines.
?????*
?????*?@param?in????the?POI?filesystem?that?contains?the?Workbook?stream.
?????*?@param?sheet?read?sheet.
?????*?@return?analysis?result.
?????*/
????public?static?Listject>?read（InputStream?in?Sheet?sheet）?{
????????final?Listject>?rows?=?new ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\
?????文件?????????142??2018-12-17?10:58??easyexcel-master\.gitignore
?????文件???????11357??2018-12-17?10:58??easyexcel-master\LICENSE
?????文件????????6441??2018-12-17?10:58??easyexcel-master\README.md
?????文件????????4829??2018-12-17?10:58??easyexcel-master\abouteasyexcel.md
?????文件???????????1??2018-12-17?10:58??easyexcel-master\easyexcel_en.md
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\img\
?????文件??????152429??2018-12-17?10:58??easyexcel-master\img\WechatIMG8.png
?????文件????????4820??2018-12-17?10:58??easyexcel-master\pom.xm
?????文件????????8083??2018-12-17?10:58??easyexcel-master\problem.md
?????文件???????13525??2018-12-17?10:58??easyexcel-master\quickstart.md
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\
?????文件????????4284??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\EasyExcelFactory.java
?????文件????????5208??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\ExcelReader.java
?????文件????????6054??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\ExcelWriter.java
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\
?????文件????????2771??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\ba
?????文件?????????477??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\ExcelAnalyser.java
?????文件????????3623??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\ExcelAnalyserImpl.java
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\v03\
?????文件???????10511??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\v03\XlsSaxAnalyser.java
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\v07\
?????文件????????4338??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\v07\XlsxRowHandler.java
?????文件????????5229??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\analysis\v07\XlsxSaxAnalyser.java
?????目錄???????????0??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\annotation\
?????文件?????????697??2018-12-17?10:58??easyexcel-master\src\main\java\com\alibaba\excel\annotation\ExcelColumnNum.java
............此處省略73個文件信息
- 上一篇：jsoup采集必應壁紙
- 下一篇：gson解析json數據 java類
評論
共有 條評論