1,报这个问题是因为使用了分页导入,一个流对象只能读取一次
public String upload(MultipartFile file) throws IOException {
EasyExcel.read(file.getInputStream(), UploadData.class, new UploadDataListener(uploadDAO)).sheet(0).doRead();
EasyExcel.read(file.getInputStream(), UploadData.class, new UploadDataListener(uploadDAO)).sheet(1).doRead();
return "success";
};
2,修改过后:
input1 = file.getInputStream();
input2 = file.getInputStream();
EasyExcel.read(input1 , UploadData.class, new UploadDataListener(uploadDAO)).sheet(0).doRead();
EasyExcel.read(input2 , UploadData.class, new UploadDataListener(uploadDAO)).sheet(1).doRead();