org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException:

Question

I'm using the following jar files: ``` dom4j-1.6.1.jar poi-3.9-20121203.jar poi-ooxml-3.9-20121203.jar poi-ooxml-schemas-3.9-20121203.jar xmlbeans-2.3.0.jar ``` Code: ``` package ExcelTest; import java.io.File; import java.io.FileInputStream; import java.util.Iterator; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class Test { public static void main(String[] args) { try { FileInputStream file = new FileInputStream(new File("G:\Selenium Jar Files\TestData\Data.xls")); //Create Workbook instance holding reference to .xlsx file XSSFWorkbook workbook = new XSSFWorkbook(file); //Get first/desired sheet from the workbook XSSFSheet sheet = workbook.getSheetAt(0); //Iterate through each rows one by one Iterator<Row> rowIterator = sheet.iterator(); while (rowIterator.hasNext()) { Row row = rowIterator.next(); //For each row, iterate through all the co…

Accepted Answer

You are trying to read `xls` with explicit implementation poi classes for `xlsx`.

G:\Selenium Jar Files\TestData\Data.xls

Either use `HSSFWorkbook` and `HSSFSheet` classes or make your implementation more generic by using shared interfaces, like;

Change:

```
XSSFWorkbook workbook = new XSSFWorkbook(file);
```

To:

```
 org.apache.poi.ss.usermodel.Workbook workbook = WorkbookFactory.create(file);
```

And Change:

```
XSSFSheet sheet = workbook.getSheetAt(0);
```

To:

```
org.apache.poi.ss.usermodel.Sheet sheet = workbook.getSheetAt(0);
```

org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException:

Solution

Problem

Related problems