侧边栏壁纸
  • 累计撰写 1,975 篇文章
  • 累计创建 73 个标签
  • 累计收到 20 条评论

目 录CONTENT

文章目录

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

猿哥
2023-03-24 / 0 评论 / 0 点赞 / 327 阅读 / 234 字

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

0
博主关闭了所有页面的评论