Adding an image to laravel-excel header

Question

I'm making an excel export using the Maatwebsite/Laravel-Excel version 3.1. I am trying to add an image to the header of every page but it doesn't seem to work.

I tried following the phpspreadsheet documentation for inserting image, but that doesn't seem to work.

$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);```

Try using the absolute path to the image instead of a relative path. — Dave, Sep 05 '19 at 08:44
@SaitamaKalbo did you ever get this working? I have the same problem. — plaintxt, Oct 16 '20 at 17:48

score 0 · Answer 1 · answered Feb 10 '22 at 05:20

this worked for me.

$filename = 'File Name';

Excel::create($filename, function($excel){

   $excel->sheet('sheet name', function($sheet){
        $objDrawing = new PHPExcel_Worksheet_Drawing;
        $objDrawing->setPath(public_path('img/headerKop.png')); //your image path
        $objDrawing->setCoordinates('A2');
        $objDrawing->setWorksheet($sheet);
   });

})->export('xls');

score -1 · Answer 2 · answered Oct 15 '20 at 07:31

-1

Try this!

$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');

answered Oct 15 '20 at 07:31

Monique Noche

1
5

Adding an image to laravel-excel header

2 Answers2