使用java和apache在excel中读取写入数据
使用java和apache在excel中读取写入数据
提问于 2019-12-02 11:49:43
我正在尝试使用Apache文件读写数据到excel。我已经导入了必要的jars，即: poi.4.1.1.jar xmlbeans ooxml ooxml
我目前编写了下面的代码，这些代码在“Workbook wb =WorkbookFactory.create(Fis)”行中失败：
package readingData;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
public class ReadDatafromExcel {
private static Sheet sh;
private static Row row;
private static Cell cell;
private static FileInputStream fis;
private static FileOutputStream fos;
public static void main(String[] args) throws Exception {
fis = new FileInputStream("C:/Users/10610985/workspace/ReadData/SampleData.xlsx");
Workbook wb = WorkbookFactory.create(fis);
// sh = wb.getSheetAt(0);
//// int firstRow = sh.getFirstRowNum();
//// System.out.println(firstRow);
//
// int lastRow = sh.getLastRowNum();
// System.out.println(lastRow);
}
}下面是我收到的错误消息：
Exception in thread "main" java.io.IOException: org/apache/commons/compress/archivers/zip/ZipFile
at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:353)
at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:316)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:234)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:200)
at readingData.ReadDatafromExcel.main(ReadDatafromExcel.java:22)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:307)
at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:134)
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.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:341)
... 4 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.compress.archivers.zip.ZipFile
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
... 11 more我试图搜索这个网络，但没有任何解决办法，我周围可以找到。任何关于我哪里出错的想法，或者如果我能做些什么来理解Workbookfactory中的各种方法。
下面是添加apache公共压缩jars后更新的错误消息。
Exception in thread "main" java.io.IOException: org/apache/commons/collections4/ListValuedMap
at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:353)
at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:316)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:234)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:200)
at readingData.ReadDatafromExcel.main(ReadDatafromExcel.java:22)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap
at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:88)
at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:135)
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.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:341)
... 4 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
... 11 more这件事解决了
从这里添加了apache通用压缩罐。https://commons.apache.org/proper/commons-compress/download_compress.cgi
从这里添加了公共集合4-4.1 jar。https://mvnrepository.com/artifact/org.apache.commons/commons-collections4/4.1
Stack Overflow用户
回答已采纳
发布于 2019-12-02 12:37:40
Add commons-collections4-4.1.jar file in your build path and try it again. It will work.
You can find it here https://mvnrepository.com/artifact/org.apache.commons/commons-collections4/4.1
if you are not using maven you can directly download the jar and add it to your project页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59138360
复制相关文章
相似问题
腾讯云开发者
