问题遇到的现象和发生背景
使用EasyExcel上传报错com.alibaba.excel.exception.ExcelDataConvertException: Can not instance class:
问题相关代码,请勿粘贴截图
EasyExcel.read(file.getInputStream(), Student.class, new UploadExcelListener()).sheet().doRead();
public class UploadExcelListener implements ReadListener<Student> {
private static final Integer BATCH_COUNT= 100;
private List<Student> cachedDataList = new ArrayList<>();
/**
* 数据转换异常等处理
* @param exception
* @param context
* @throws Exception
*/
@Override
public void onException(Exception exception, AnalysisContext context) throws Exception {
ReadListener.super.onException(exception, context);
}
/**
* 读取表头数据
* @param headMap
* @param context
*/
@Override
public void invokeHead(Map<Integer, ReadCellData<?>> headMap, AnalysisContext context) {
ReadListener.super.invokeHead(headMap, context);
}
@Override
public void invoke(Student data, AnalysisContext context) {
cachedDataList.add(data);
if(cachedDataList.size() >= BATCH_COUNT){
System.out.println("读取excel表格到100行,插入数据库");
cachedDataList.clear();
}
}
/**
* 额外信息(批注、超链接、合并单元格信息读取)
* @param extra
* @param context
*/
@Override
public void extra(CellExtra extra, AnalysisContext context) {
ReadListener.super.extra(extra, context);
}
@Override
public void doAfterAllAnalysed(AnalysisContext context) {
System.out.println(cachedDataList);
}
@Override
public boolean hasNext(AnalysisContext context) {
return ReadListener.super.hasNext(context);
}
}
运行结果及报错内容
com.alibaba.excel.exception.ExcelDataConvertException: Can not instance class:
我的解答思路和尝试过的方法
这个是因为什么呀 求各位看看 怎么解决