https://bz.apache.org/bugzilla/show_bug.cgi?id=57593
--- Comment #12 from Vasili <[email protected]> --- I've tried Biff8EncryptionKey.setCurrentUserPassword("VelvetSweatshop"); before opening through WorkbookFactory.create(fis); and the result was the same: org.apache.poi.EncryptedDocumentException: The supplied spreadsheet seems to be an Encrypted .xlsx file. It must be decrypted before use by XSSF, it cannot be used by HSSF at org.apache.poi.hssf.usermodel.HSSFWorkbook.getWorkbookDirEntryName(HSSFWorkbook.java:252) I agree with you that the file might had been protected, then unprotected, or may have some particular protected parts, nobody knows, may be only MS guys/developers. I assume, if it can be opened in MS Excel (without any indication about the encryption), it is a valid BIFF8 file. Excel is doing something automatically (fixes?) after any saving: $ file 096113YE06.xlsm 096113YE06.xlsm: Composite Document File V2 Document, Encrypted $ file 096113YE06_just_resaved.xlsm 096113YE06_just_resaved.xlsm: Microsoft Excel 2007+ What exact usage/API are you suggesting for HSSF? It is for sure not xml file, it is a binary file. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
