poi excel name is too long: �+�� aL

古城微笑少年丶 2023-10-13 16:07 12阅读 0赞

## 1， 版本 ##

![在这里插入图片描述][d4e07735d90c40d7a83c4d21acd48d9f.png]

## 2，问题 ##

Exception in thread "main" org.apache.poi.util.RecordFormatException: Unable to construct record instance
    	at org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:98)
    	at org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:345)
    	at org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:307)
    	at org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:273)
    	at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:175)
    	at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:136)
    	at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processWorkbookEvents(HSSFEventFactory.java:82)
    	at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processWorkbookEvents(HSSFEventFactory.java:54)
    	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:66)
    	at com.alibaba.excel.ExcelReader.read(ExcelReader.java:56)
    	at com.alibaba.excel.read.builder.ExcelReaderSheetBuilder.doRead(ExcelReaderSheetBuilder.java:65)
    	at com.paas.ocr.controller.OcrController.main(OcrController.java:72)
    Caused by: java.lang.IllegalArgumentException: Name is too long: �+����aL(\,(����,	�Tw�|i���f�p���:�2<��PQ�^N��x{��>���%�rCo�Q��Q;��pS��͂Ə����.�ܥ���׎7�S[�^+b�rw�
    	at org.apache.poi.hssf.record.WriteAccessRecord.setUsername(WriteAccessRecord.java:101)
    	at org.apache.poi.hssf.record.WriteAccessRecord.<init>(WriteAccessRecord.java:69)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    	at org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:84)

## 3，解决方法 ##

> 权限问题

wps权限设置  
关闭权限

![在这里插入图片描述][71564aec7d0548c7aadb1d3b7186420e.png]

[d4e07735d90c40d7a83c4d21acd48d9f.png]: https://img-blog.csdnimg.cn/d4e07735d90c40d7a83c4d21acd48d9f.png
[71564aec7d0548c7aadb1d3b7186420e.png]: https://img-blog.csdnimg.cn/71564aec7d0548c7aadb1d3b7186420e.png