错误描述
org.apache.poi.util.RecordFormatException: Unable to construct record instance
at org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:94)
at org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:339)
at org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:289)
at org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:255)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:488)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:343)
at org.apache.poi.hssf.usermodel.HSSFWorkbookFactory.createWorkbook(HSSFWorkbookFactory.java:64)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:167)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:112)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:253)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:221)
at com.e21.common.utils.poi.ExcelUtil.importExcel(ExcelUtil.java:256)
at com.e21.common.utils.poi.ExcelUtil.importExcel(ExcelUtil.java:243)
at com.e21.common.utils.poi.ExcelUtil.importExcel(ExcelUtil.java:232)
at com.e21.controller.goods.MkGoodsController.importData(MkGoodsController.java:169)
解决方法
Excel表格有问题,可能Excel固定了表头等操作,使这个excel无法读取了,筛选、冻结、排序这些都会造成excel导入失效