reading .xlsx file in netbeans. what do i have to do to make my code run?

[bhavin ragha]

so i have a java file that tries to read the .xlsx file but im getting an error. what do i have to do to get started.
i have added poi-3.9-20121203.jar and poi-ooxml-3.9-20121203.jar
is there anything else i have to do.

this is the error i get:

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlOptions
	at org.apache.poi.POIXMLDocumentPart.<clinit>(POIXMLDocumentPart.java:53)
	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:72)
	at testout.Testout.main(Testout.java:36)
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlOptions
	at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
	... 3 more
Java Result: 1

USEING THIS CODE

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import org.apache.poi.ss.usermodel.*;
//import org.apache.poi.ss.usermodel.WorkbookFactory;
//import org.apache.poi.hssf.usermodel.*;
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;
import org.apache.poi.xssf.usermodel.*;


/**
 *
 * @author Bhavin Ragha
 */
public class Testout {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws Exception {
        // TODO code application logic here
        
    File fileName = new File("C:\\Users\\Bhavin Ragha\\Documents\\NetBeansProjects\\Year3\\testout\\test.xlsx");
    InputStream inp = new FileInputStream(fileName);
    
    Workbook wb = WorkbookFactory.create(inp);
    
    Sheet sheet = wb.getSheetAt(0);
    Row row = sheet.getRow(2);
    Cell cell = row.getCell(3);
    if (cell == null)
        cell = row.createCell(3);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("a test");

    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);
    fileOut.close();
    }
}

[Rob Spoor]

It looks like you need XMLBeans as well.

[bhavin ragha]

Rob Spoor wrote:It looks like you need XMLBeans as well.

omg thanks so much. i have been asking for ages now. so i found out that i need the following

xbean.jar
xbean_xpath.jar
xmlbeans-qname.jar
dom4j-1.6.1.jar
poi-ooxml-3.8-20120326.jar
poi_ooxml-schemas-3.8-20120326.jar
poi-3.8-20120326.jar

i have them thanks to you. there is 1 more. dom4j-1.6.1.jar i found the link. click me

once again thanks so much ROB!!! :-)

[Rob Spoor]

You're welcome