将图像添加到laravel-excel标题

Question

我正在使用Maatwebsite/Laravel-Excel版本3.1导出excel。我试图在每个页面的页眉添加一个图像，但似乎不起作用。

我尝试按照phpspreadsheet文档插入图像，但似乎不起作用。

$drawing->setName('PhpSpreadsheet logo');
$drawing->setPath('./images/PhpSpreadsheet_logo.png');
$drawing->setHeight(36);
$spreadsheet->getActiveSheet()->getHeaderFooter()->addImage($drawing, \PhpOffice\PhpSpreadsheet\Worksheet\HeaderFooter::IMAGE_HEADER_LEFT);```

Answer 1

尝尝这个!

$drawing = new Drawing();
$drawing->setName('Logo');
$drawing->setDescription('This is my logo');
$drawing->setPath(public_path('/images/PhpSpreadsheet_logo.png'));
$drawing->setHeight(36);
$drawing->setCoordinates('A1');