laravel如何导出excel中带有图片？

excel 解压后是个目录，如果有图片附件的话就是在这个目录下的这个文件路径

早上刚写了同样的需求，一样的代码但我的并没有文本...是不是其他地方导致的？

之前写过类似的，但是列宽可能会不生效。

刚写的一个需求这是一个封装的导出类，最后的 drawings 是导出时添加图片，正常的话把你那个单元格填充信息去掉为空然后把图片插入即可

use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Events\BeforeExport;
use Maatwebsite\Excel\Concerns\WithDrawings;
use PhpOffice\PhpSpreadsheet\Exception;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
//省略部分格式代码.....
 public function map($row): array
    {
        $package = Package::find($row->package_id);
        return [
            $row->id,
            $package?$package->name:'套餐不存在或已删除',
            $row->intercept_status?Orders::$interceptStatusTexts[$row->intercept_status]:'暂无',
            $row->intercept_msg,
            $row->api_sync?Orders::$apiSyncTexts[$row->api_sync]:'暂无',
            $row->api_valid?Orders::$apiValidTexts[$row->api_valid]:'暂无',
            $row->api_lock,
            "\t".$row->api_order_no,
            "\t".$row->business_order_no,
            "\t".$row->order_no,
            $row->status,
            "\t".$row->phonenum,
            $row->contact,
            "\t".$row->mobile,
            "\t".$row->iden_card_id,
            $row->iden_card_name,
            $row->open_status?Orders::$openStatusTexts[$row->open_status]:'暂无',
            $row->open_message,
            $row->express_status?Orders::$expressStatusTexts[$row->express_status]:'暂无',
            "\t".$row->express_no,
            $row->express_name,
            //证件照
            '',
            '',
            '',
            $row->express_address,
            $row->remark,
            $row->active_status?Orders::$activeStatusTexts[$row->active_status]:'',
            $row->active_time,
            $row->first_charge_status?Orders::$firstChargeStatusTexts[$row->first_charge_status]:'',
            $row->first_charge_time,
            $row->first_charge_amount,
            $row->created_at,
            $row->updated_at
        ];
    }

public function drawings()
    {
        $drawings = [];
        $rowIndex = 2; // Start from the second row (first row is for headings)

        foreach ($this->rowsWithImages as $row) {
            if ($row->idcard_front) {
                $drawing = new Drawing();
                $drawing->setName('证件照正面');
                $drawing->setDescription('证件照正面');
                $drawing->setPath(public_path($row->idcard_front));
                $drawing->setHeight(50);
                $drawing->setCoordinates('V' . $rowIndex);
                $drawings[] = $drawing;
            }

            if ($row->idcard_back) {
                $drawing = new Drawing();
                $drawing->setName('证件照反面');
                $drawing->setDescription('证件照反面');
                $drawing->setPath(public_path($row->idcard_back));
                $drawing->setHeight(50);
                $drawing->setCoordinates('W' . $rowIndex);
                $drawings[] = $drawing;
            }

            if ($row->user_with_idcard) {
                $drawing = new Drawing();
                $drawing->setName('手持证件照');
                $drawing->setDescription('手持证件照');
                $drawing->setPath(public_path($row->user_with_idcard));
                $drawing->setHeight(50);
                $drawing->setCoordinates('X' . $rowIndex);
                $drawings[] = $drawing;
            }

            $rowIndex++;
        }

        return $drawings;
    }