how to read a protected Excel file

Topics: User Forum
Feb 6, 2011 at 7:07 PM

I have a set of Excel file with workbook protection and worksheet protection. If I try to read them with PHPExcel, I am not able to read anything from them or do anything such as SetActiveSheet.

I know the password for the protection. I hope to use the password to unprotect the workbook and the worksheet. How can I do that?

Thank you,

Feb 6, 2011 at 7:20 PM
Edited Feb 6, 2011 at 7:20 PM

PHPExcel is unable to read password protected workbooks.. There are no problems with sheet or cell protection, which are simply flagged as protected in the structural data of the workbook. But protected workbooks themselves are encrypted, and I have no idea what encryption algorithm is used, so no idea how it can be decoded. The same applies to writing workbook protection.

Apr 18, 2012 at 1:01 PM

Is this still the case ?

Mar 3, 2016 at 11:11 AM
I also have an issue with reading excel file with protected worksheet. I tried with Version 1.8.1 but no luck so for. Could anybody guide me on this ?