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模式。在上层做了模型转换的封装，让使用者更加简单方便
支持多表头
ExcelWriter writer = EasyExcelFactory.getWriter(out);
//写第一个sheet, sheet1 数据全是List<String> 无模型映射关系
Sheet sheet1 = new Sheet(1, 3);
sheet1.setSheetName("第一个sheet");
//设置列宽 设置每列的宽度
Map columnWidth = new HashMap();
columnWidth.put(0,10000);columnWidth.put(1,40000);columnWidth.put(2,10000);columnWidth.put(3,10000);
sheet1.setColumnWidthMap(columnWidth);
sheet1.setHead(createTestListStringHead());
//or 设置自适应宽度
//sheet1.setAutoWidth(Boolean.TRUE);
writer.write1(createTestListObject(), sheet1);
//写第二个sheet sheet2 模型上打有表头的注解，合并单元格
Sheet sheet2 = new Sheet(2, 3, JavaModel1.class, "第二个sheet", null);
sheet2.setTableStyle(createTableStyle());
writer.write(createTestListJavaMode(), sheet2);
//写第三个sheet包含多个table情况
Sheet sheet3 = new Sheet(3, 0);
sheet3.setSheetName("第三个sheet");
Table table1 = new Table(1);
table1.setHead(createTestListStringHead());
writer.write1(createTestListObject(), sheet3, table1);
//写sheet2 模型上打有表头的注解
Table table2 = new Table(2);
table2.setTableStyle(createTableStyle());
table2.setClazz(JavaModel1.class);
writer.write(createTestListJavaMode(), sheet3, table2);
//关闭资源
writer.finish();
out.close();资源文件列表
easyexcel-master/.gitignore , 142
easyexcel-master/LICENSE , 11357
easyexcel-master/README.md , 6441
easyexcel-master/abouteasyexcel.md , 4829
easyexcel-master/easyexcel_en.md , 1
easyexcel-master/img/WechatIMG8.png , 152429
easyexcel-master/pom.xml , 4820
easyexcel-master/problem.md , 8083
easyexcel-master/quickstart.md , 13525
easyexcel-master/src/main/java/com/alibaba/excel/EasyExcelFactory.java , 4284
easyexcel-master/src/main/java/com/alibaba/excel/ExcelReader.java , 5208
easyexcel-master/src/main/java/com/alibaba/excel/ExcelWriter.java , 6054
easyexcel-master/src/main/java/com/alibaba/excel/analysis/BaseSaxAnalyser.java , 2771
easyexcel-master/src/main/java/com/alibaba/excel/analysis/ExcelAnalyser.java , 477
easyexcel-master/src/main/java/com/alibaba/excel/analysis/ExcelAnalyserImpl.java , 3623
easyexcel-master/src/main/java/com/alibaba/excel/analysis/v03/XlsSaxAnalyser.java , 10511
easyexcel-master/src/main/java/com/alibaba/excel/analysis/v07/XlsxRowHandler.java , 4338
easyexcel-master/src/main/java/com/alibaba/excel/analysis/v07/XlsxSaxAnalyser.java , 5229
easyexcel-master/src/main/java/com/alibaba/excel/annotation/ExcelColumnNum.java , 697
easyexcel-master/src/main/java/com/alibaba/excel/annotation/ExcelProperty.java , 706
easyexcel-master/src/main/java/com/alibaba/excel/annotation/FieldType.java , 151
easyexcel-master/src/main/java/com/alibaba/excel/constant/ExcelXmlConstants.java , 464
easyexcel-master/src/main/java/com/alibaba/excel/context/AnalysisContext.java , 2410
easyexcel-master/src/main/java/com/alibaba/excel/context/AnalysisContextImpl.java , 4317
easyexcel-master/src/main/java/com/alibaba/excel/context/WriteContext.java , 8603
easyexcel-master/src/main/java/com/alibaba/excel/event/AnalysisEventListener.java , 557
easyexcel-master/src/main/java/com/alibaba/excel/event/AnalysisEventRegisterCenter.java , 591
easyexcel-master/src/main/java/com/alibaba/excel/event/OneRowAnalysisFinishEvent.java , 704
easyexcel-master/src/main/java/com/alibaba/excel/event/WriteHandler.java , 674
easyexcel-master/src/main/java/com/alibaba/excel/exception/ExcelAnalysisException.java , 452
easyexcel-master/src/main/java/com/alibaba/excel/exception/ExcelGenerateException.java , 405
easyexcel-master/src/main/java/com/alibaba/excel/metadata/BaseRowModel.java , 743
easyexcel-master/src/main/java/com/alibaba/excel/metadata/CellRange.java , 992
easyexcel-master/src/main/java/com/alibaba/excel/metadata/ExcelColumnProperty.java , 1150
easyexcel-master/src/main/java/com/alibaba/excel/metadata/ExcelHeadProperty.java , 6998
easyexcel-master/src/main/java/com/alibaba/excel/metadata/Font.java , 732
easyexcel-master/src/main/java/com/alibaba/excel/metadata/IndexValue.java , 725
easyexcel-master/src/main/java/com/alibaba/excel/metadata/Sheet.java , 3421
easyexcel-master/src/main/java/com/alibaba/excel/metadata/Table.java , 1053
easyexcel-master/src/main/java/com/alibaba/excel/metadata/TableStyle.java , 1427
easyexcel-master/src/main/java/com/alibaba/excel/modelbuild/ModelBuildEventListener.java , 1535
easyexcel-master/src/main/java/com/alibaba/excel/parameter/AnalysisParam.java , 1194
easyexcel-master/src/main/java/com/alibaba/excel/parameter/ExcelWriteParam.java , 826
easyexcel-master/src/main/java/com/alibaba/excel/parameter/GenerateParam.java , 1149
easyexcel-master/src/main/java/com/alibaba/excel/support/ExcelTypeEnum.java , 1013
easyexcel-master/src/main/java/com/alibaba/excel/util/CollectionUtils.java , 11838
easyexcel-master/src/main/java/com/alibaba/excel/util/IndexValueConverter.java , 2167
easyexcel-master/src/main/java/com/alibaba/excel/util/ObjectUtils.java , 33053
easyexcel-master/src/main/java/com/alibaba/excel/util/POITempFile.java , 929
easyexcel-master/src/main/java/com/alibaba/excel/util/PositionUtils.java , 802
easyexcel-master/src/main/java/com/alibaba/excel/util/RowUtil.java , 192
easyexcel-master/src/main/java/com/alibaba/excel/util/StringUtils.java , 45958
easyexcel-master/src/main/java/com/alibaba/excel/util/StyleUtil.java , 2156
easyexcel-master/src/main/java/com/alibaba/excel/util/TypeUtil.java , 8162
easyexcel-master/src/main/java/com/alibaba/excel/util/WorkBookUtil.java , 2635
easyexcel-master/src/main/java/com/alibaba/excel/write/ExcelBuilder.java , 1399
easyexcel-master/src/main/java/com/alibaba/excel/write/ExcelBuilderImpl.java , 5173
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/ReadTest.java , 6989
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/WriteTest.java , 7929
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/listen/AfterWriteHandlerImpl.java , 2351
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/listen/ExcelListener.java , 818
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/model/BaseReadModel.java , 546
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/model/BaseWriteModel.java , 625
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/model/ReadModel.java , 2181
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/model/ReadModel2.java , 2577
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/model/WriteModel.java , 2595
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/util/DataUtil.java , 3603
easyexcel-master/src/test/java/com/alibaba/easyexcel/test/util/FileUtil.java , 279
easyexcel-master/src/test/resources/2003.xls , 105984
easyexcel-master/src/test/resources/2007.xlsx , 159492
easyexcel-master/src/test/resources/temp.xlsx , 11303
easyexcel-master/update.md , 833