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
