Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
From: Matt Rogghe <mrogghe@blazent.com>
To: POI Users List <user@poi.apache.org>
Subject: Excel 2007+ with password protection
Thread-Topic: Excel 2007+ with password protection
Thread-Index: Ac0CxvNJxph75p+FQqSukHoXajzjog==
Date: Thu, 15 Mar 2012 16:16:18 +0000
Message-ID: <84FC8BBE1CE6B2458B946E61D3C5B29315BAB023@MBX244.domain.local>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_84FC8BBE1CE6B2458B946E61D3C5B29315BAB023MBX244domainloc_"
MIME-Version: 1.0

--_000_84FC8BBE1CE6B2458B946E61D3C5B29315BAB023MBX244domainloc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I've been experimenting with opening password protected (not encrypted) wor=
kbooks.  The HSSF (2003 and lower) versions seem to work fine when using th=
e org.apache.poi.hssf.record.crypto.Biff8EncryptionKey methods.  The XSSF m=
ethods seem to be problematic.

poi-3.8-beta5

Using the following methods to determine workbook version and get an object=
 to work with: POIFSFileSystem.hasPOIFSHeader(inputStream), POIXMLDocument.=
hasOOXMLHeader(inputStream) as well as the generic WorkbookFactory.create(i=
nputStream).

When I come across a 2007+ workbook that has been saved as password protect=
ed POI determines that the file is in HSSF/BIFF format.

Error generated:
The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is =
it really an excel file?

Has anyone had success opening password protected 2007+ files?

Steps to reproduce:
1.  Create a new Excel file using Excel 2007+.
2.  Save As ->
3. Click Tools -> General Options
4.  Enter a password in both or either fields.
5. OK and save.
6. Attempt to read the file using POI.

--_000_84FC8BBE1CE6B2458B946E61D3C5B29315BAB023MBX244domainloc_--