org.apache.poi.util.RecordFormatException: Unable to construct record instance

" "

错误描述

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导入失效