java - java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipArchiveOutputStream
问题描述
试图在 linux 中从 .xlsx 读取数据,但出现此错误。
FAILED: readExcel
java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipArchiveOutputStream
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:233)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:166)
at org.apache.poi.ooxml.POIXMLDocument.openPackage(POIXMLDocument.java:89)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:336)
at com.admin.integration.manage.PolicyEnforcementTest.readExcel(PolicyEnforcementTest.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
at org.testng.TestRunner.privateRun(TestRunner.java:648)
at org.testng.TestRunner.run(TestRunner.java:505)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
at org.testng.SuiteRunner.run(SuiteRunner.java:364)
at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
at org.testng.TestNG.runSuites(TestNG.java:1049)
at org.testng.TestNG.run(TestNG.java:1017)
at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 30 more
这是我尝试过的代码,但对我一点用都没有。试图添加不同的罐子,但对我不起作用。
XSSFWorkbook srcBook = new XSSFWorkbook(util.getDownloadsPath() + util.getExcelFilePath());
XSSFSheet sourceSheet = srcBook.getSheetAt(0);
int rownum=12;
XSSFRow sourceRow = sourceSheet.getRow(rownum);
XSSFCell cell1=sourceRow.getCell(0);
XSSFCell cell2=sourceRow.getCell(24);
解决方案
推荐阅读
- reactjs - 如何在 redux reducer 中更改嵌套数组的值
- php - 如何获取调用函数的脚本名称?
- javascript - 如何更改 js 以获取地点和地址自动完成?
- visual-foxpro - 如何将 Foxpro 7 查询结果导出为 CSV 或 XLS
- php - SSL 的 Google Recaptcha V2 问题
- python - 安装 Plotly 后 Jupyter Notebook 突然变慢了
- android - 在 Delphi 10.3 Rio 中写入外部 SD 卡
- spatstat - 如何在 spatstat 中以 1 km 分辨率进行点过程模型
- winapi - UpdateLayeredWindowIndirect 函数的更新区域是什么?
- javascript - 此代码的输出必须是 john james 和 rose。但 joh 出现在输出中。为什么?