I wrote a very short code to use POI, but failed. Help is greatly
appreciated!
I could not even run this short codes.
I have downloaded the newest version of Apache files, including:
poi-4.0.jar, poi-ooxml-4.0.0.jar; poi-ooxml-schemas-4.0.0.jar,
xmlbeans-3.0.1.jar, and commons-collection4-4.2.jar
------------------------------------------------------------------
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class POIExcel {
public static void main(String[] args) throws IOException {
FileInputStream fis = new
FileInputStream("C:/Users/xxxx/Desktop/Input.xlsx");
Workbook wb = new XSSFWorkbook(fis);
--------------------------------------------------------
Here is the error message:
Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/commons/compress/archivers/zip/ZipFile
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:298)
at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:37)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:307)
at TestNG_Project.POIExcel.main(POIExcel.java:14)
Caused by: java.lang.ClassNotFoundException:
org.apache.commons.compress.archivers.zip.ZipFile
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 4 more
--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
