laravel-excel 无法使用带有图像的刀片导出 xls 文件

使用 Laravel-Excel 库时，有时我们可能会遇到一个问题：无法将带有图像的刀片导出为 xls 文件。这个问题可能会让我们感到困惑，因为 Laravel-Excel 库本应该支持导出各种类型的数据到 Excel 文件中，包括带有图像的刀片。在本文中，我们将探讨这个问题的解决方法，并提供一个案例代码来帮助你理解如何实现这一功能。

composer require maatwebsite/excel
composer require phpoffice/phpexcel

php
'providers' => [
    // ...
    Maatwebsite\Excel\ExcelServiceProvider::class,
],

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider"

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 PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
class UserExport implements FromCollection, WithHeadings, ShouldAutoSize, WithEvents
{
    public function collection()
    {
        return User::all();
    }
    public function headings(): array
    {
        return ['Name', 'Email', 'Avatar'];
    }
    public function registerEvents(): array
    {
        return [
            AfterSheet::class => function(AfterSheet $event) {
                $users = User::all();
                foreach ($users as $index => $user) {
                    $avatar = imagecreatefromjpeg($user->avatar); // 假设头像是一个 JPEG 图像
                    
                    $drawing = new Drawing();
                    $drawing->setPath($user->avatar);
                    $drawing->setCoordinates('C' . ($index + 2));
                    $drawing->setWidthAndHeight(50, 50);
                    $drawing->setWorksheet($event->sheet->getDelegate());
                }
            },
        ];
    }
}

php
namespace App\Http\Controllers;
use App\Exports\UserExport;
use Maatwebsite\Excel\Facades\Excel;
class UserController extends Controller
{
    public function exportUsers()
    {
        return Excel::download(new UserExport, 'users.xls');
    }
}