寄语:明日复明日明日何其多
用处:无规则表格列导入到数据库
所需工具类简介
官网:
EasyExcel是一个基于Java的简单、省内存的读写Excel的开源项目。在尽可能节约内存的情况下支持读写百M的Excel。 github地址:https://github.com/alibaba/easyexcel
项目引入依赖包:
<!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
示例:
package cn.bdqn.mybatiesplus.inteceptor;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import java.util.Map;
public class MyEasyExcel extends AnalysisEventListener<Map<Integer,String>> {
public MyEasyExcel() {
}
Map<Integer,String> headMap= null;//存放表头数据
@Override
public void invokeHeadMap(Map<Integer,String > headMap, AnalysisContext context){
this.headMap=headMap;
}
@Override
public void invoke(Map<Integer, String> map, AnalysisContext analysisContext) {
for (Integer key: headMap.keySet()){
String s = map.get(key);//即可读取对应数据
}
}
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
}
}
注意:此类不可交给spring容器管理