[Bug]: images in header

[ziolupo68]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1.36

What version of Laravel are you using?

8.83.1

What version of PHP are you using?

8.0.14

Describe your issue

I'm trying to insert image in header (or footer) but is not showing anything. Even using dd on i.e. getOddHeader is just showing an empty string

How can the issue be reproduced?

    public function registerEvents(): array
    {
      return [
          BeforeSheet::class => function(BeforeSheet $event){
            $sheet=$event->getDelegate();
            $drawing = new HeaderFooterDrawing();
            $drawing->setName('Logo');
            $drawing->setDescription('This is my logo');
            $drawing->setPath(public_path('/images/logo_small.jpg'));
            $drawing->setOffsetX(10);
            $drawing->setOffsety(10);
            $drawing->setWidth(170);
            $drawing->setHeight(100);
            $sheet->getHeaderFooter()->setOddHeader("Packing List")->addImage($drawing, \PhpOffice\PhpSpreadsheet\Worksheet\HeaderFooter::IMAGE_HEADER_RIGHT);
          },
      ];
    }

What should be the expected behaviour?

I expect to see the image in the sheet header

[patrickbrouwers]

You probably have to do this in the AfterSheet event. I'm guessing the package overrides those cells.

[ziolupo68]

I tried the same code in AfterSheet and it was not working. So I moved in BeforeSheet but it's not working as well.

[jorgedav-id]

You should add the &G code in the Header on setOddHeader("Packing List"), here is an example:

public function registerEvents(): array
    {
        return [
            BeforeSheet::class => function(BeforeSheet $event) {
                $sheet = $event->getDelegate();
                $logo = new HeaderFooterDrawing();
                $logo->setName('logo ');
                $logo->setPath(public_path('/images/logo.png'));
                $logo->setHeight(40);
                $sheet->getHeaderFooter()->setOddHeader('&L&G &C&B Header Example');
                $sheet->getHeaderFooter()->addImage($logo, HeaderFooter::IMAGE_HEADER_LEFT);
                $sheet->getHeaderFooter()->setOddFooter('&C&B&I&9http://mysite.test/' .  '&RPag. &P of &N');
            },
        ];
    }

See info about the codes available for header and footer here: https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#setting-printer-options-for-excel-files