Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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 the .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.
Thanks!