读取的时候发生了错误，看看是哪里的问题？ #372

89333367 · 2024-03-11T08:29:14Z

文件是这个
1.xls

代码是这个

<!-- https://central.sonatype.com/artifact/org.ttzero/eec -->
        <dependency>
            <groupId>org.ttzero</groupId>
            <artifactId>eec</artifactId>
            <version>0.5.13</version>
        </dependency>
        <!-- https://central.sonatype.com/artifact/org.ttzero/eec-e3-support -->
        <dependency>
            <groupId>org.ttzero</groupId>
            <artifactId>eec-e3-support</artifactId>
            <version>0.5.12</version>
        </dependency>

@Test
    void t2() {
        try (ExcelReader reader = ExcelReader.read(Paths.get("d:/tmp/1.xls"))) {
            reader.sheet(0).dataRows().forEach(new Consumer<Row>() {
                @Override
                public void accept(Row row) {
                    log.info("{}", row.toMap());
                }
            });
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

错误描述

org.ttzero.excel.reader.ExcelReadException: Read excel failed.

	at org.ttzero.excel.reader.ExcelReader.read(ExcelReader.java:819)
	at org.ttzero.excel.reader.ExcelReader.read(ExcelReader.java:195)
	at uml.tech.worksupport.Tests.读数据2(Tests.java:91)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:214)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:210)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:66)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:35)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:54)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:107)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67)
	at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:114)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:86)
	at org.junit.platform.launcher.core.DefaultLauncherSession$DelegatingLauncher.execute(DefaultLauncherSession.java:86)
	at org.junit.platform.launcher.core.SessionPerRequestLauncher.execute(SessionPerRequestLauncher.java:53)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:57)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
	at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:232)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:55)
Caused by: java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at org.ttzero.excel.reader.ExcelReader.read(ExcelReader.java:807)
	... 71 more
Caused by: java.lang.NoClassDefFoundError: org/ttzero/excel/entity/style/BuiltInNumFmt$NumFmt
	at org.ttzero.excel.reader.BIFF8Reader.parseGlobalSetting(BIFF8Reader.java:600)
	at org.ttzero.excel.reader.BIFF8Reader.parseDocSummaryInformation(BIFF8Reader.java:581)
	at org.ttzero.excel.reader.BIFF8Reader.init(BIFF8Reader.java:187)
	at org.ttzero.excel.reader.BIFF8Reader.<init>(BIFF8Reader.java:100)
	... 76 more
Caused by: java.lang.ClassNotFoundException: org.ttzero.excel.entity.style.BuiltInNumFmt$NumFmt
	at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
	at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
	... 80 more

The text was updated successfully, but these errors were encountered:

wangguanquan · 2024-03-11T09:16:12Z

兼容问题，由于开发时间有限xls并没有发布v0.5.13版本，所以有兼容问题，可以将eec和eec-e3-support降版到v0.5.12，兼容性对照表

89333367 · 2024-03-11T09:19:55Z

兼容问题，由于开发时间有限xls并没有发布v0.5.13版本，所以有兼容问题，可以将eec和eec-e3-support降版到v0.5.12，兼容性对照表

嗯，降到0.5.12，数据能读出来了，但是最后会报个错。

wangguanquan · 2024-03-11T09:40:39Z

这个异常也是兼容性引起的，兼容性问题应该早于0.5.12，我晚点发一个eec-e3-support的hotfix版本吧，0.5.13的功能并没有实现只能保证不报错

89333367 · 2024-03-11T09:42:34Z

这个异常也是兼容性引起的，兼容性问题应该早于0.5.12，我晚点发一个eec-e3-support的hotfix版本吧，0.5.13的功能并没有实现只能保证不报错

嗯，你有空再说吧。不急这个，我手动转成xlsx，再读取

wangguanquan · 2024-03-12T10:49:26Z

eec-e3-support v0.5.13 推了，不过新版本又发现新的兼容问题。。。

89333367 · 2024-03-12T10:51:13Z

eec-e3-support v0.5.13 推了，不过新版本又发现新的兼容问题。。。

软件有bug正常。最终能搞定就ok

wangguanquan · 2024-04-22T12:51:53Z

v0.5.14已修复xls兼容问题且新增模板文件导出等新特性

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

读取的时候发生了错误，看看是哪里的问题？ #372

读取的时候发生了错误，看看是哪里的问题？ #372

89333367 commented Mar 11, 2024

wangguanquan commented Mar 11, 2024

89333367 commented Mar 11, 2024

wangguanquan commented Mar 11, 2024

89333367 commented Mar 11, 2024

wangguanquan commented Mar 12, 2024

89333367 commented Mar 12, 2024

wangguanquan commented Apr 22, 2024

读取的时候发生了错误，看看是哪里的问题？ #372

读取的时候发生了错误，看看是哪里的问题？ #372

Comments

89333367 commented Mar 11, 2024

wangguanquan commented Mar 11, 2024

89333367 commented Mar 11, 2024

wangguanquan commented Mar 11, 2024

89333367 commented Mar 11, 2024

wangguanquan commented Mar 12, 2024

89333367 commented Mar 12, 2024

wangguanquan commented Apr 22, 2024