问在Laravel中添加密码到Excel文件

EN

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Events\BeforeExport;

class UserExport implements FromCollection, WithHeadings, ShouldAutoSize, WithEvents
{
    protected $year;
    protected $month;

    public function __construct($year,$month)
    {
        $this->year = $year;
        $this->month = $month;
    }

    public function registerEvents(): array
    {
        return [
            BeforeExport::class  => function(BeforeExport $event) {
                $event->writer->getSecurity()->setLockWindows(true);
                $event->writer->getSecurity()->setLockStructure(true);
                $event->writer->getSecurity()->setWorkbookPassword("123456");
            },

            AfterSheet::class    => function(AfterSheet $event) {
                $event->sheet->setRightToLeft(true);
            },
        ];
    }
}