PhpSpreadsheet - Add Workbook Password

[DanRz]

Hey,

I have the following script that looks to make an excel document using PHPSpreadsheet... the script works great, but it doesn't apply the password to the workbook... what am I missing?

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
// Information
$arrayData[] = array('cells');

// Make File Name
$filename = 'file-'.time().'.xlsx';

$spreadsheet = new Spreadsheet();

$spreadsheet->getActiveSheet()->getProtection()->setSheet(true);
$security = $spreadsheet->getSecurity();
$security->setLockWindows(true);
$security->setLockStructure(true);
$security->setWorkbookPassword("PhpSpreadsheet");

$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Report Generated '. date(DATE_FORMAT_LONG));
$sheet->fromArray($arrayData, NULL, 'A3');

header('Content-Disposition: attachment;filename='.$filename);

$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');

Thanks

Dan

[maxxd]

Looks like you can set a password on the document, sheet, or cell: https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#setting-security-on-a-spreadsheet

[DanRz]

I tried adding that code but it still doesn't seem to password protect the actual document...

Just unable to edit a sheet or cell...

$security = $spreadsheet->getSecurity();
$security->setLockWindows(true);
$security->setLockStructure(true);
$security->setWorkbookPassword("PhpSpreadsheet");

 

[DanRz]

Looks like PhpSpreadsheet can't actually protect the opening of a document... see https://github.com/PHPOffice/PhpSpreadsheet/issues/761

Which is odd because to me the documentation reads like it does...

[DanRz]

https://github.com/nick322/secure-spreadsheet adding this repo works.