org.apache.poi.openxml4j.exceptions.InvalidFormatException: Can't read content types part ! | Community
Skip to main content
Level 3
March 14, 2018
Solved

org.apache.poi.openxml4j.exceptions.InvalidFormatException: Can't read content types part !

  • March 14, 2018
  • 3 replies
  • 8273 views

Hi Team,

I am trying ti read the .xlsx  file from eclipse using the maven project.

Here all the dependencies I am using

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi</artifactId>

<version>3.9</version>

</dependency>

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi-ooxml</artifactId>

<version>3.9</version>

</dependency>

<dependency>

<groupId>dom4j</groupId>

<artifactId>dom4j</artifactId>

<version>1.6.1</version>

</dependency>

<dependency>

<groupId>org.apache.xmlbeans</groupId>

<artifactId>xmlbeans</artifactId>

<version>2.3.0</version>

</dependency>

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi-ooxml-schemas</artifactId>

<version>3.9</version>

</dependency>

code for reading the excel file

Workbook workBook = WorkbookFactory.create(new File(SourceFile));

            Sheet metadataSheet = workBook.getSheet(SheetName);

Its returning the exception. "org.apache.poi.openxml4j.exceptions.InvalidFormatException: Can't read content types part !"

I have tried by using this code as well

XSSFWorkbook workbook = new XSSFWorkbook(excelFile);

XSSFSheet metadataSheet = workbook.getSheet(SheetName)

it is returning this exception " org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught Throwable

java.lang.NullPointerException: in is null"

Please guide me or advice how to resolve this.

I have tried using the jxl java API , I am able to read the .xls but not able to read .xlsx by using this.

Thanks In Advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

You need to replace the use of this API with one that reads the file format (XLSX) you mention here.

I recommend looking at using: Apache POI - the Java API for Microsoft Documents

We have a document that talks about using this API to work with WORD docs -- Scott's Digital Community: Creating an Adobe Experience Manager HTL Component that parses MS Word Documents

3 replies

smacdonald2008
smacdonald2008Accepted solution
Level 10
March 15, 2018

You need to replace the use of this API with one that reads the file format (XLSX) you mention here.

I recommend looking at using: Apache POI - the Java API for Microsoft Documents

We have a document that talks about using this API to work with WORD docs -- Scott's Digital Community: Creating an Adobe Experience Manager HTL Component that parses MS Word Documents

smacdonald2008
Level 10
March 15, 2018

This API states it supports this file type:

Level 2
March 15, 2018

Hi Scott,

I am facing the problem with POI as well. I have given the details of code and decencies using in it. 

POI is working with beans project but with maven I am seeing the exceptions.

I am not sure what is missing in it.

Thanks