导入Excel报错:org.apache.poi.util.RecordFormatException: Unhandled Continue Record followining class org

java开发,在做Excel导入的时候,会遇到这个问题,先贴出来报错信息

1.  
   2022-05-18 19:15:54.415 [http-nio-10019-exec-8] ERROR o.jeecg.common.exception.JeecgBootExceptionHandler:69 - Unhandled Continue Record followining class org.apache.poi.hssf.record.TabIdRecord
2.  
   org.apache.poi.util.RecordFormatException: Unhandled Continue Record followining class org.apache.poi.hssf.record.TabIdRecord
3.  
   at org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:361)
4.  
   at org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:255)
5.  
   at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:488)
6.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:343)
7.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:400)
8.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:381)
9.  
   at org.jeecg.modules.***.test.service.impl.***ServiceImpl.getWorkbook(***ServiceImpl.java:332)
10.  
    at org.jeecg.modules.***.test.service.impl.***ServiceImpl.importChangeExcelTransferOfCadres(***ServiceImpl.java:237)
11.  
    at org.jeecg.modules.***.test.service.impl.***ServiceImpl$$FastClassBySpringCGLIB$$be16ad9a.invoke(<generated>)
12.  
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
13.  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687)
14.  
    at org.jeecg.modules.***.test.service.impl.***ServiceImpl$$EnhancerBySpringCGLIB$$7315699c.importChangeExcelTransferOfCadres(<generated>)
15.  
    at org.jeecg.modules.***.test.controller.***Controller.importExcel(***Controller.java:171)
16.  
    at org.jeecg.modules.***.test.controller.***Controller$$FastClassBySpringCGLIB$$95a23514.invoke(<generated>)
17.  
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
18.  
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
19.  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
20.  
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
21.  
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
22.  
    at org.jeecg.common.aspect.DictAspect.doAround(DictAspect.java:55)
23.  
    at sun.reflect.GeneratedMethodAccessor229.invoke(Unknown Source)
24.  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
25.  
    at java.lang.reflect.Method.invoke(Method.java:498)
26.  
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
27.  
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
28.  
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
29.  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
30.  
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
31.  
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
32.  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
33.  
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
34.  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
35.  
    at org.jeecg.modules.***.test.controller.***Controller$$EnhancerBySpringCGLIB$$3383d253.importExcel(<generated>)
36.  
    at sun.reflect.GeneratedMethodAccessor241.invoke(Unknown Source)
37.  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
38.  
    at java.lang.reflect.Method.invoke(Method.java:498)
39.  
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
40.  
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
41.  
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
42.  
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
43.  
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
44.  
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
45.  
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
46.  
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
47.  
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
48.  
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
49.  
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
50.  
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
51.  
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
52.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
53.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
54.  
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
55.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
56.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
57.  
    at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
58.  
    at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
59.  
    at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
60.  
    at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
61.  
    at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
62.  
    at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
63.  
    at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
64.  
    at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
65.  
    at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
66.  
    at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
67.  
    at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
68.  
    at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
69.  
    at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
70.  
    at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
71.  
    at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
72.  
    at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
73.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
74.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
75.  
    at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
76.  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
77.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
78.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
79.  
    at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
80.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
81.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
82.  
    at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
83.  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
84.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
85.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
86.  
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
87.  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
88.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
89.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
90.  
    at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
91.  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
92.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
93.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
94.  
    at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
95.  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
96.  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
97.  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
98.  
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
99.  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
100.  
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
101.  
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
102.  
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
103.  
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
104.  
     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
105.  
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
106.  
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
107.  
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
108.  
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
109.  
     at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
110.  
     at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
111.  
     at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
112.  
     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
113.  
     at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
114.  
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
115.  
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
116.  
     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
117.  
     at java.lang.Thread.run(Thread.java:748)

这个问题刚开始以为是工作簿是中文的,百度搜也搜不出来结果

后来发现是Excel文档中,某个值左右两边某个地方包含空格.....................

最后,还有这个博主的文章,帮助了不少

这篇好文章是转载于：学新通技术网