I’m trying to parse a excel file using apache poi but I’m getting the error “org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: The supplied data appears to be a raw XML file. Formats such as Office 2003 XML are not supported“. I research & found xls format not supported by StreamingReader. I saved my file to xlsx format but still I’m getting same error.

String name = “test.xls”;
File f = new File();
InputStream is = new FileInputStream(f);

Workbook workbook = StreamingReader.builder()
.rowCacheSize(100).bufferSize(4096).open(is);

Sheet sheet = workbook.getSheetAt(0);

Exception

Exception in thread “main” org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: The supplied data appears to be a raw XML file. Formats such as Office 2003 XML are not supported
at org.apache.poi.openxml4j.opc.internal.ZipHelper.verifyZipHeader(ZipHelper.java:153)
at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipFile(ZipHelper.java:203)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:140)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:272)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:181)
at com.monitorjbl.xlsx.impl.StreamingWorkbookReader.init(StreamingWorkbookReader.java:113)
at com.monitorjbl.xlsx.impl.StreamingWorkbookReader.init(StreamingWorkbookReader.java:91)
at com.monitorjbl.xlsx.StreamingReader$Builder.open(StreamingReader.java:251)
at com.publisher.main.ContentParser.main(ContentParser.java:22)