poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: Excel 2007+ with password protection
Date Thu, 15 Mar 2012 16:21:20 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message