While we gratefully accept contributions to POI - there are restrictions you should be aware of before you build a contribution based on another license type.

Please see http://apache.org/legal/resolved.html for a list of licenses that are and are NOT acceptable.

Unfortunately OpenOffice.org uses a license that is not acceptable - LGPL.

That means it can't be used as an example in implementing this feature.

What you can do is look to see if the specification is covered by Microsoft's OSP. Start here http://www.microsoft.com/Interop/osp/default.mspx and see if you can find the spec.

Regards,
Dave

On Apr 22, 2009, at 10:17 AM, Mahesh Ganapathy wrote:

Can Open Office open password protected excel files? If it can, then the algorithm could be leveraged by POI. I do not have access to Oo right this moment, hence the question. If this is feasible, I can spend some time developing the necessary code with some guidance from the masters.
Sent via BlackBerry by AT&T

-----Original Message-----
From: MSB <[email protected]>

Date: Wed, 22 Apr 2009 10:09:42
To: <[email protected]>
Subject: Re: How to read password-protected XLSX file?



I hung back from answering because I do not have mucg experience with XSSF and the OpenXML file format. However, with regard to the older binary file
format, I know that HSSF could not open password protected spreadsheet
files. The reason is that they are encrypted and the algorithm is not - at least as far as I am aware - in the public domain. As I said, I cannot be certain but I would expect that the same is true of the xlsx, xlsm and xlsb
files that Office 2007 can produce.

Just as an aside, I know that OpenOffice can read and write xlsx files. It
also has a programming interface - UNO - that allows you to control an
instance of OpenOffice and manipulate files; abit like OLE but it is
platform independent. It may - and this is another guess on my part - be the case that you could use this API to process password protected spreadsheet
files using Java code. No promises though.


J Keller wrote:

Can anyone please point me to some docs and/or examples that show how to
read a password-protected spreadsheet?  Thanks.


--
View this message in context: 
http://www.nabble.com/How-to-read-password-protected-XLSX-file--tp23161302p23175636.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to