Hi Team,
Expression evaluation error at function 'readexcelsheetpaging': org.apache.pol.openxml4j.exceptions.OLE2NotOfficexmlFileException. The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF Instead of XSSF)
Can anyone help on this to which function help to check format in excel
Thanks
Divya
Discussion posts and replies are publicly visible
Looks like file is older .xls format but function expects .xlsx
Shubham Aware It is the excel sheet with XLSX format,when I pass stopReadingAtFirstBlankRow:false() its giving the error
Pass stopReadingAtFirstBlankRow as 0 instead of false.
This is the wrong file format as pointed out by Google Gemini.
The Root Cause
Apache POI uses two different "drivers" to handle Excel files based on their format:
- HSSF (Horrible Spreadsheet Format): For the old OLE2 binary format used in Excel '97–2003 (.xls).
- XSSF (XML Spreadsheet Format): For the OOXML format used in Excel 2007 and newer (.xlsx).
The error message OfficeXmlFileException is POI's way of saying: "You gave me a modern XML-based file, but you're using the HSSF classes which only understand the old binary format."
The extension might be .xlsx but the internals of the file might not be.
There's a quick and easy way to test this - if they .xlsx file opens in a Zip File Viewer (7zip, etc) and you see a valid file tree, or (alternatively) if you can rename the file (or a duplicate copy of the file) to have ".zip" as the final extension, let's say "myTestFile.xlsx.zip", it should open and be browsable in a zip file viewer context. If it's not openable in this manner, it's NOT a proper "OOXML" format file.