NullpointerException when trying to read XLSX file

apache-poi, excel, java

Solution

Now I've dowloaded the latest packages:

- poi-src-3.9-20121203.zip (As source)

- xmlbeans-2.6.0.zip

- jsr173_1.0_api.jar

- resolver.jar

- xbean.jar

- xbean_xpath.jar

- xmlbeans-qname.jar

- xmlpublic.jar

- ooxml-schemas-1.1.jar

- dom4j-1.6.1.jar

- commons-codec-1.8.jar

- commons-logging-1.1.3.jar

- ant.jar (ant 1.7)

And your test2.xlsx were read without problems:

  public static void main(String arg []){
    try {
      //File existingXlsx = new File("/app/app.xlsx");
      File existingXlsx = new File("c:/Java/poi-3.9/test-data/__theproblem/test2.xlsx");
      System.out.println("File Exists: " + existingXlsx.exists());

      Workbook workbook = WorkbookFactory.create(existingXlsx);

    } catch (Exception e) {
      e.printStackTrace();
    }
  }

Are you sure you're using ooxml-schemas-1.1.jar as the POI documentation recommends?

EDIT

Hmm. It's work for me from jar too.

I have downloaded poi-bin-3.9-20121203.tar.gz from http://poi.apache.org/download.html

Made a new project in Eclipse, extracted all the jars from the zip:

- lib/commons-codec-1.5.jar

- lib/commons-logging-1.1.jar

- lib/dom4j-1.6.1.jar

- lib/junit-3.8.1.jar

- lib/log4j-1.2.13.jar

- lib/poi-3.9-20121203.jar

- lib/poi-examples-3.9-20121203.jar

- lib/poi-excelant-3.9-20121203.jar

- lib/poi-ooxml-3.9-20121203.jar

- lib/poi-ooxml-schemas-3.9-20121203.jar

- lib/poi-scratchpad-3.9-20121203.jar

- lib/stax-api-1.0.1.jar

- lib/xmlbeans-2.3.0.jar

- Add the test xlsx:

- test-data/test2.xlsx

- The test Java:

- src/XlsxReadTest1.java

Source:

    import java.io.File;
    import org.apache.poi.ss.usermodel.Workbook;
    import org.apache.poi.ss.usermodel.WorkbookFactory;

    public class XlsxReadTest1 {
      public static void main(String arg []){
        try {

          File existingXlsx = new File("c:/Java/__Work/apache_POI/poi-3.9-bin/test-data/test2.xlsx");
          System.out.println("File Exists: " + existingXlsx.exists());

          Workbook workbook = WorkbookFactory.create(existingXlsx);

          System.out.println("A1: " + workbook.getSheetAt(0).getRow(0).getCell(0).getStringCellValue());

        } catch (Exception e) {
          e.printStackTrace();
        }
      }
    }

Run. (Tried with jdk1.7.0_07, jdk1.6.0_31)

Result:

File Exists: true
A1: Testing Edit

"Testing Edit" is the content of the first cell on the first sheet of your file.

I think, You may try this, from scratch.

(Maybe you are using other jars for your project, whom interfere with this jars in the class loader? Class loader is a cunning guy...)

Problem

Original source