FastExcel 能快速简单读取 excel 数据,将 Apache POI 进行了薄封装,基于注解,更加易于使用 本次更新: 1.升级poi版本至3.15 2.适配3.15最新的API 3.修复将整数判定为浮点数问题
使用样例:
1 2 3 4 5 6 7 8 9 10 | FastExcel fastExcel = new FastExcel( "E:/data.xlsx" );
fastExcel.setSheetName( "活动信息数据" );
List<MyTest> tests = fastExcel.parse(MyTest. class );
if ( null != tests && !tests.isEmpty()) {
for (MyTest myTest : tests) {
LOG.debug( "记录:{}" , myTest.toString());
}
} else {
LOG.debug( "没有结果" );
}
|
映射类
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | public class MyTest {
@MapperCell (cellName = "名称" )
private String name;
@MapperCell (cellName = "联系电话" )
private String phone;
@MapperCell (cellName = "地址" )
private String address;
@MapperCell (cellName = "一级分类ID" )
private int type;
@MapperCell (cellName = "经度" )
private double lat;
|
|