[已解决]请教关于在Laravel-Admin中使用Laravel-Excel V3.* 导出带图片的EXCEL

<?php

namespace App\Admin\Extensions;

use Encore\Admin\Grid;
use Encore\Admin\Grid\Exporters\ExcelExporter;
use Maatwebsite\Excel\Concerns\WithDrawings;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
use Illuminate\Support\Facades\Storage;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithTitle;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Events\AfterSheet;


class StocksExporter extends ExcelExporter implements  ShouldAutoSize,WithTitle,WithEvents,WithMapping
{
    use Exportable;
    protected $fileName = '采购订单.xlsx';

    protected $columns = [
        'website_id' => '店铺',
        'start_at'      => '订单日期',
        'product_title'   => '产品标题',
        'img_url' => '图片',
        'product_option' => '产品选项',
        'required_count' => '采购数量',
    ];

    public function __construct()
    {
        parent::__construct();
        $this->fileName = '采购订单'.request()->start_at.'.xlsx';
    }

    public function registerEvents(): array
    {
        return [
            AfterSheet::class => function(AfterSheet $event) {
                $event->sheet->getColumnDimension('D')->setAutoSize(false)->setWidth(20);

                $count = [
                    count($this->getCollection()), //column count
                ];

                for($i=0;$i<$count[0];$i++) //iterate based on row count
                {
                    $event->sheet->getRowDimension($i+2)->setRowHeight(60);
                }

                foreach($this->getCollection() as $k=>$val)
                {
                    $url = $val['img_url'];
                    $file_name = basename(parse_url($url, PHP_URL_PATH));
                    $drawing = new Drawing();
                    $drawing->setName('image');
                    $drawing->setDescription('image');
                    $drawing->setPath(public_path('uploads/'.$file_name));
                    $drawing->setHeight(70);
                    $drawing->setOffsetX(5);
                    $drawing->setOffsetY(5);
                    $drawing->setCoordinates('D'.($k+2));
                    $drawing->setWorksheet($event->sheet->getDelegate());
                }
            }
        ];
    }

    public function title(): string
    {
        return request()->start_at;
    }


    public function map($stock) : array
    {
        return [
            data_get($stock, 'website.url'),
            $stock->start_at->format('Y-m-d'),
            $stock->product_title.' - '.$stock->product_option,
            //$stock->img_url,
            '',
            $stock->product_option,
            $stock->required_count,
        ];
    }
}

用WithEvents解决了。

为什么之前用drawings 插入的是新的一行？有知道的麻烦分享一下。

多研究研究撒 我正准备搞个类似的环境试试呢结果你就解决了 :joy:

@德国科隆街头的大胡子 是啊，应该多研究一下。 主要这个需求现在还被砍了，哈哈哈

@ldonne 可否贴一下控制器的代码,想请教下具体怎么使用