Excel workbook protected with password.

Topics: Developer Forum, User Forum
Aug 13, 2012 at 9:20 AM

Hello,

For my volleybal club we have a excel file which is protected with a password. I try to automate something for the website and therefore I want to open the Excel to import data in to a database.

Is it possible to open the Excel by PHPExcell?

(It's for me not a problem that I have the password in the code or when I load the excel file with PHPExcel, a pop-up window pops-up with the question "fill in the password")

Coordinator
Aug 13, 2012 at 1:28 PM

The same identical questions from three different people in the last three days, all visible on the very first page of the discussion list, and all with a heading that indicates they're about exactly the same topic.

 

PHPExcel does not support password-protected workbooks.

Simply adding a password to a load call might be simple for a developer, but it is not simple for the library when I can't find any Microsoft documentation identifying how workbook level encryption is implemented.... makes it very difficult to know how it should be decrypted.