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]
