Java bytea schema对应_java用poi包导入excel时出现poi . Characters larger than 4 bytes are not supported: byte ...

org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException

at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:62)

at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:427)

at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:156)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:254)

at com.test.test.getWorkbok(test.java:55)

at com.test.test.main(test.java:37)

Caused by: java.lang.reflect.InvocationTargetException

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.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:60)

... 5 more

Caused by: java.io.CharConversionException: Characters larger than 4 bytes are not supported: byte 0x88 implies a length of more than 4 bytes

at org.apache.xmlbeans.impl.piccolo.xml.UTF8XMLDecoder.decode(UTF8XMLDecoder.java:162)

at org.apache.xmlbeans.impl.piccolo.xml.XMLStreamReader$FastStreamDecoder.read(XMLStreamReader.java:762)

at org.apache.xmlbeans.impl.piccolo.xml.XMLStreamReader.read(XMLStreamReader.java:162)

at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yy_refill(PiccoloLexer.java:3474)

at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:3958)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)

at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)

at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1270)

at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1257)

at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)

at org.openxmlformats.schemas.spreadsheetml.x2006.main.SstDocument$Factory.parse(Unknown Source)

at org.apache.poi.xssf.model.SharedStringsTable.readFrom(SharedStringsTable.java:115)

at org.apache.poi.xssf.model.SharedStringsTable.(SharedStringsTable.java:102)

... 10 more

Exception in thread "main" java.lang.NullPointerException

at com.test.test.main(test.java:38)

数据一直尝试未果。后台经过度娘，了解到是文件编码有问题，存在特殊字符。

但具体是哪里出现了问题,是什么格式的数据？表情符号导致这种情况,没有结论。

反复导出数据尝试，依然报错。

最后，将excel转换为2003版本的xls格式。大小翻了好几倍，居然成功了。

数据最终入库，但是原因不详，待查….