On Sun, 18 Mar 2007, Darren S. Eyers wrote:
I believe we can not open a workbook/sheet that is password protected in
POI when you have the password?
Questions:
1. Has anybody extended the code to do this?
Not that I'm aware of, but we'd be interested if they did :)
2. Will this feature be there in the future 3.0.x ?
Probably not. The encryption stuff in the office file formats is a real
mess. Looking at powerpoint (excel is similar, but I don't know it as
well):
* A couple of the records half way through the file and un-encrypted. All
the others are
* One of these records contains a text string of the name of the algorithm
used
* You are responsible for turning the name into decryption engine, so you
can then decrypt the other records
* There are half a dozen possible algorithms for each key length. They all
have very similar names, almost all of them contain the phrase
"Microsoft Enhanced" (which normally means doesn't follow the spec),
and not all of them even have names that hint at what algorith they use
In theory, if we could figure out how to match something like "Microsoft
Base Cryptographic Provider v1.0" to some java code that'll provide
decryption, we could support protected files. Until then, alas we can't
support them.
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
