set Workbook password

[chrisvidal]

I am trying to ad a password to the whole Excel file, to allow or forbid reading of the content, using events, but it does not do anything.

public function registerEvents(): array
    {
        return [
            BeforeWriting::class => function(BeforeWriting $event) {
                $spreadsheet = $event->getWriter()->getDelegate();
                $security = $spreadsheet->getSecurity();
                $security->setLockWindows(true);
                $security->setLockStructure(true);
                $security->setWorkbookPassword("test");
                $security->setRevisionsPassword('test');
            },
            AfterSheet::class => function(AfterSheet $event) {
                $event->sheet->freezePane('A2', 'A2');

                $protection = $event->getSheet()->getDelegate()->getProtection();
                $protection->setPassword('PhpSpreadsheet');
                $protection->setSheet(true);
                $protection->setSort(true);
                $protection->setInsertRows(true);
                $protection->setFormatCells(true);
            },
        ];
    }

[patrickbrouwers]

If I remember correctly PhpSpreadsheet only supports protecting data changes, not reading. If you need something like that, you'd probably need to go the password-protected zip route. You can try Stackoverflow, perhaps someone within the PhpSpreadsheet community knows more.

[chrisvidal]

yes I confirm, password reading protection is not available.
Great suggestion for the password zip file, thanks a bunch!

[chrisvidal]

the Zip road is a hell, so far I haven't figured out how to install / enable Zip extension for PHP.
it looks like it is installed and running but keep having this Class ZipArchive::class not found.
Is there any other PHP Excel library out there?
Is there any other Enncrypt solution than Zip available?
at your knowledge. thanks

[patrickbrouwers]

That's weird, PhpSpreadsheet doesn't work without the zip extension, so that should already be available? Perhaps stackoverflow can be of help to get the zip ext working for you.

[chrisvidal]

I have a ZipArchive::class not found

[patrickbrouwers]

Repeating the same error, doesn't really help haha :) As mentioned before, I would recommend trying Stackoverflow (or perhaps Laracasts) for help. It goes beyond on which I can help, my time on open source is very limited atm.

[hudaraj]

Is this same for CSV as well

[patrickbrouwers]

You can't password protect a csv. You would need to go for a zipped (or encrypted) solution if you want to protect the file.

[laze]

It is 2025. Read protection isn't available yet?