在Laravel中添加密码到Excel文件

composer require maatwebsite/excel

Maatwebsite\Excel\ExcelServiceProvider::class,

'Excel' => Maatwebsite\Excel\Facades\Excel::class,

php artisan make:controller ExcelController

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;
use App\Exports\PasswordsExport;

class ExcelController extends Controller
{
    public function exportPasswords()
    {
        return Excel::download(new PasswordsExport(), 'passwords.xlsx')->withPassword('your_password');
    }
}

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;
use Illuminate\Support\Collection;

class PasswordsExport implements FromCollection
{
    public function collection()
    {
        return new Collection([
            ['Username', 'Password'],
            ['user1', 'password1'],
            ['user2', 'password2'],
            // Add more data rows as needed
        ]);
    }
}

Route::get('/export-passwords', 'ExcelController@exportPasswords');