读取代码
// 前端传过来的文件
multipartfile file;
inputstream inputstream = file.getinputstream();
// 读取excel数据,边读取边处理;
easyexcel.read(inputstream, importskuidlist.class, new skuidexcelistener(sendcouponcusrecordservice)).sheet().doread();
解析对象
public class importskuidlist{
@excelproperty(index = 0)
/** 商品编号*/
private long skuid;
// 省略get set
....
}
listener
public class skuidexcelistener extends analysiseventlistener {
private static final logger logger = loggerfactory.getlogger(skuidexcelistener.class);
// spring的方式需要通过构造函数传进来
private sendcouponcusrecordservice sendcouponcusrecordservice;
/**
* 每隔100条存储数据库,实际使用中可以3000条,然后清理list ,方便内存回收
*/
private static final int batch_count = 100;
private