-
-
shihh 小试身手Lv3
发表于2020-12-8 16:16
悬赏1
已解决
楼主
在手动创建标准集之后，进行Excel的导入，一直报错主要是什么原因呢？？是我的标准集属性不合适还是别的？？
上附两张图片，还请大神帮我解答疑惑
上附两张图片，还请大神帮我解答疑惑
最佳答案
shihh 发表于 2020-12-8 17:05
是的： Cannot get a STRING value from a NUMERIC cell
检查一下excel对应字段的数据类型是否一致
11个回答
完整的报错是Cannot get a STRING value from a NUMERIC cell的吗
凹凸曼 发表于 2020-12-8 16:58
完整的报错是Cannot get a STRING value from a NUMERIC cell的吗
是的： Cannot get a STRING value from a NUMERIC cell
凹凸曼 发表于 2020-12-8 16:58
完整的报错是Cannot get a STRING value from a NUMERIC cell的吗
2020-12-08 17:14:00 java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1050)
at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:404)
at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:356)
at com.esen.edatastandard.port.StandardImport.doImport(StandardImport.java:84)
at com.esen.edatastandard.port.StandardImport$$FastClassBySpringCGLIB$$69e3ed03.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at com.esen.edatastandard.port.StandardImport$$EnhancerBySpringCGLIB$$15b325b8.doImport()
at com.esen.edatastandard.port.ImportRunner.call(ImportRunner.java:38)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
谢谢啦！昨天的问题已经解决。只是又有个新的问题，就是导入的表他所有的内容是空的，就比如：主题之类的 都是空的。。。这个是啥原因造成的？？
