线程“main”中的异常java.lang.NoClassDefFoundError：org / apache / xmlbeans / XmlException [英] Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException

问题描述

我必须在java中读取xls文件。我使用poi-3.6来读取Eclipse中的xls文件。但是我得到这个错误线程中的异常主java.lang.NoClassDefFoundError：org / apache / xmlbeans ReadExcel2.main中的/ XmlException（ReadExcel2.java:38）。

I have to read xls file in java.I used poi-3.6 to read xls file in Eclipse.But i m getting this ERROR"Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException at ReadExcel2.main(ReadExcel2.java:38)".

我添加了以下jars
1）poi-3.6-20091214 .jar
2）poi-contrib-3.6-20091214.jar
3）poi-examples-3.6-20091214.jar
4）poi-ooxml-3.6-20091214.jar
5）poi-ooxml-schemas-3.6-20091214.jar
6）poi-scratchpad-3.6-20091214.jar

I have added following jars 1)poi-3.6-20091214.jar 2)poi-contrib-3.6-20091214.jar 3)poi-examples-3.6-20091214.jar 4)poi-ooxml-3.6-20091214.jar 5)poi-ooxml-schemas-3.6-20091214.jar 6)poi-scratchpad-3.6-20091214.jar

以下是我的代码使用：

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.Iterator;
import java.util.List;
import java.util.ArrayList;
public class ReadExcel {

    public static void main(String[] args) throws Exception {
        //
        // An excel file name. You can create a file name with a full path
        // information.
        //
        String filename = "C:\\myExcel.xl";
        //
        // Create an ArrayList to store the data read from excel sheet.
        //
        List sheetData = new ArrayList();

        FileInputStream fis = null;
        try {
            //
            // Create a FileInputStream that will be use to read the excel file.
            //
            fis = new FileInputStream(filename);

            //
            // Create an excel workbook from the file system.
            //
           // HSSFWorkbook workbook = new HSSFWorkbook(fis);
            Workbook workbook = new XSSFWorkbook(fis);  

            //
            // Get the first sheet on the workbook.
            //
            Sheet sheet = workbook.getSheetAt(0);

            //
            // When we have a sheet object in hand we can iterator on each
            // sheet's rows and on each row's cells. We store the data read
            // on an ArrayList so that we can printed the content of the excel
            // to the console.
            //
            Iterator rows = sheet.rowIterator();
            while (rows.hasNext()) {
                Row row = (XSSFRow) rows.next();
                Iterator cells = row.cellIterator();

                List data = new ArrayList();
                while (cells.hasNext()) {
                    Cell cell = (XSSFCell) cells.next();
                    data.add(cell);
                }

                sheetData.add(data);
            }
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (fis != null) {
                fis.close();
            }
        }

        showExelData(sheetData);
    }
    private static void showExelData(List sheetData) {
        //
        // Iterates the data and print it out to the console.
        //
        for (int i = 0; i < sheetData.size(); i++) {
            List list = (List) sheetData.get(i);
            for (int j = 0; j < list.size(); j++) {
                Cell cell = (XSSFCell) list.get(j);
                System.out.print(cell.getRichStringCellValue().getString());
                if (j < list.size() - 1) {
                    System.out.print(", ");
                }
            }
            System.out.println("");
        }
    }
}

请帮助。
感谢预期，
问候，
Dheeraj！

Please help. thanks in anticipation, Regards, Dheeraj!

推荐答案

你需要 xmlbeans 。

NoClassDefFoundError 表示：

编译当前正在执行的类时存在搜索的类定义，但无法再找到该定义。

The searched-for class definition existed when the currently executing class was compiled, but the definition can no longer be found.

因此，下次出现这样的异常时，这意味着某些第三方库需要另一个第三方库。然后使用谷歌（或任何其他方式）来查找这是哪个库。
此外，大多数图书馆在其文档和/或发行版中明确说明了它们的依赖关系。

So next time you get an exception like this, it means that some 3rd party library requires another 3rd party library. Then use google (or any other means) to find which library this is. Furthermore, most libraries state clearly in their documentations and/or distributions what are their dependencies.

这篇关于线程“main”中的异常java.lang.NoClassDefFoundError：org / apache / xmlbeans / XmlException的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！