On Thu, 15 Mar 2012, Matt Rogghe wrote:
I've been experimenting with opening password protected (not encrypted) workbooks. The HSSF (2003 and lower) versions seem to work fine when using the org.apache.poi.hssf.record.crypto.Biff8EncryptionKey methods. The XSSF methods seem to be problematic.
See http://poi.apache.org/encryption.html for details on how to read .xlsx password protected files
When I come across a 2007+ workbook that has been saved as password protected POI determines that the file is in HSSF/BIFF format.
Password protected .xlsx files are slightly confusingly wrapped in an OLE2 container
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
