原因是POI限制了字节数8224,因为xls文件微软官方也做了限制,但是实际文件出现了这个问题,有没有什么办法可以绕过? 异常代码
EasyExcel.read(fis).sheet().doReadSync();
ExcelReader excelReader = EasyExcel.read(fis).registerReadListener(listener).build();
List<ReadSheet> sheets = excelReader.excelExecutor().sheetList();
异常提示 Exception in thread "main" org.apache.poi.util.RecordFormatException: The content of an excel record cannot exceed 8224 bytes at org.apache.poi.hssf.record.RecordInputStream.nextRecord(RecordInputStream.java:230) at org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:253) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:168) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:129) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processWorkbookEvents(HSSFEventFactory.java:80) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processWorkbookEvents(HSSFEventFactory.java:53) at com.alibaba.excel.analysis.v03.XlsSaxAnalyser.execute(XlsSaxAnalyser.java:136) at com.alibaba.excel.analysis.ExcelAnalyserImpl.analysis(ExcelAnalyserImpl.java:124) at com.alibaba.excel.ExcelReader.read(ExcelReader.java:63) at com.alibaba.excel.ExcelReader.read(ExcelReader.java:53) at com.alibaba.excel.read.builder.ExcelReaderSheetBuilder.doReadSync(ExcelReaderSheetBuilder.java:80) 建议描述