Java程序使用Apache POI让我奇怪的例外 [英] Java Program using Apache POI giving me weird Exceptions

问题描述

我有让我的项目离地面一些严重的困难。我有以下的code：

I am having some serious difficulty getting my project off the ground. I have the following code:

FileInputStream file = new FileInputStream(new File("src/retestchecker/test_sheet.xlsx"));
//Get the workbook instance for XLS file 
XSSFWorkbook workbook = new XSSFWorkbook(file);

//Get first sheet from the workbook
XSSFSheet sheet = workbook.getSheetAt(0);

Row row = sheet.getRow(0);
Cell x = row.getCell(3);

System.out.println(x);

我得到这个错误，我不知道这意味着什么：

I am getting this error and I am not sure what it means:

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
    at retestchecker.RetestChecker.main(RetestChecker.java:23)
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException
    at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    ... 1 more
Java Result: 1

我使用Netbeans和被2015年5月11日发布的Apache POI的最新版本。

I am using Netbeans and the latest version of Apache POI that was released May 11, 2015.

行23错误指的便是这一行：

The line 23 that the error refers to is this line:

XSSFWorkbook workbook = new XSSFWorkbook(file);

我在做什么错了？

What am I doing wrong?

推荐答案

您缺少的xmlbeans罐（甚至更多）

You are missing the xmlbeans jar (and possibly more)

的Apache POI拥有描述所有的组件和它们的依赖，还是得心应手页如果你使用Maven这一切都为你照顾

Apache POI has a handy page describing all of the components and their dependencies, or if you use Maven it's all taken care of for you

在一个二进制版本，你会发现在 OOXML-LIB 子目录的XMLBeans。补充一点，和其他任何广口瓶需要你使用到类路径中的组件

In a binary release, you'll find xmlbeans in the ooxml-lib subdirectory. Add that, and any other jars needed for the components you're using to your classpath

这篇关于Java程序使用Apache POI让我奇怪的例外的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！