Read a password protected xlsx with Claudi XLSX

[Nando88]

I am trying to read a password protected XLSX with Claudie XLSX, but I don't know if this is possible, or if the only way to do this is with activex?

Please let me know if this can be done with Claudie XLSX.

Thanks in advance.

[GerdW]

Hi Nando,

did you already ask the maker(s) of this "ClaudieXLSX" reader? They should know the answer!

[rolfk]

It doesn't seem to support password protection in any way. And Excel knows several levels of password protection.

- Worksheet and Workbook protection: This should actually be not a problem as the content of a spreadsheet is not encrypted. The password is used to calculate a hash and the attributes tell Excel what operations should be protected. An external application like this tool not supporting this functionality should not be bothered by this.

XLSX document encryption: This is on file level similar to the file protection of ZIP files (an XLSX file is a ZIP file too). This encrypts the entire contents of each protected data stream in the file with the hash generated from the password. This would require the library to be aware of the password functionality and use the underlaying ZIP file archive functions with the correct password when opening the file. Since the library has no password parameter for the Create and Open function I think it is save to say that it does not support this kind of password protection in any way.