I am using laravel 9 and using Maatwebsite. I want to set background image in excel. Here I did
class myExport implements FromView, WithEvents ,WithDrawings
{
  public function view(): View
   {
     return view('report');
   }
   public function drawings()
    {
    $drawing = new Drawing();
    $drawing->setName('Background Text');
    $drawing->setDescription('This text ');
    $drawing->setPath(public_path('assets/img/draft.png'));
    $drawing->setCoordinates('A1'); 
    return [$drawing];
}
Image shows successfully but not appears in background . Thanks inadvance
Also tried with
public function registerEvents(): array
{
    return [
        BeforeSheet::class => function (BeforeSheet $event) {
            $spreadsheet = new Spreadsheet();
            $event->sheet->getDelegate()->setActiveSheetIndex(0);
            $event->sheet->getDelegate()->getActiveSheet()
                ->getHeaderFooter()
                ->setOddFooter('&L&BPage &P of &N');
            $event->sheet->getDelegate()->getActiveSheet()
                ->setShowGridlines(false); // Optional: Hide gridlines
            $event->sheet->getDelegate()->getActiveSheet()
                ->setSheetBackground('assets/img/draft.png'); 
        },
    ]; 
via Chebli Mohamed
 
Aucun commentaire:
Enregistrer un commentaire