PHPExcel Download Protected Book

I have 35 protected books. I am using PHPExcel to extract information from related excel files. Unfortunately, PHPExcel was not able to download the file I suspect because of a protected workbook. Here is my code:

$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($inputFileName);

Is there any workaround that allows PHPExcel to extract information from a protected workbook?

Thanks in advance.

+3
source share
2 answers

Please note that from version 1.8.0, PHPExcel supports reading Excel5 protected workbooks.

+3
source

In short, PHPExcel does not support protected sheets / workbook. See: http://phpexcel.codeplex.com/discussions/244865

0
source

All Articles