excellaravellaravel-5laravel-5.6laravel-excel

How can I change color a character laravel excel maatwebsite?


I get tutorial from here : https://laravel-excel.maatwebsite.nl/3.0/exports/extending.html

So I use version 3

My excel like this :

enter image description here

I want to change it to be like this :

enter image description here

So I want the character England change to red color and bold

I try like this :

namespace App\Exports;
...
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\BeforeExport;
use Maatwebsite\Excel\Events\AfterSheet;

class SummaryExport implements FromView, WithEvents
{
    ...
    public function registerEvents(): array
    {
        return [
            AfterSheet::class    => function(AfterSheet $event) {
                $event->sheet->styleCells(
                    'B1:D1',
                    [
                        'borders' => [
                            'outline' => [
                                'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
                                'color' => ['argb' => 'EB2B02'],
                            ],
                        ]
                    ]
                );
            },
        ];
    }
}

There exist error like this :

Method Maatwebsite\Excel\Sheet::styleCells does not exist.

How can I solve this error?


Solution

  • You may register macro within a service provider's boot method. For example App\Providers\AppServiceProvider provider's will look like as: <?php

    namespace App\Providers;
    
    use Illuminate\Support\ServiceProvider;
    use \Maatwebsite\Excel\Sheet;
    
    class AppServiceProvider extends ServiceProvider
    {
        /**
         * Bootstrap any application services.
         *
         * @return void
         */
        public function boot()
        {
            //
            Sheet::macro('styleCells', function (Sheet $sheet, string $cellRange, array $style) {
                $sheet->getDelegate()->getStyle($cellRange)->applyFromArray($style);
            });
        }
    
        /**
         * Register any application services.
         *
         * @return void
         */
        public function register()
        {
            //
        }
    }
    

    You should create different service provider to resister this kind of macro for isolating third party's concern.

    For font color set font style :

    namespace App\Exports;
    ...
    use Maatwebsite\Excel\Concerns\WithEvents;
    use Maatwebsite\Excel\Events\BeforeExport;
    use Maatwebsite\Excel\Events\AfterSheet;
    
    class SummaryExport implements FromView, WithEvents
    {
        ...
        public function registerEvents(): array
        {
            return [
                AfterSheet::class    => function(AfterSheet $event) {
                    $event->sheet->styleCells(
                        'B1:D1',
                        [
                            //Set border Style
                            'borders' => [ 
                                'outline' => [
                                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
                                    'color' => ['argb' => 'EB2B02'],
                                ],
                               
                            ],
    
                            //Set font style
                            'font' => [
                                'name'      =>  'Calibri',
                                'size'      =>  15,
                                'bold'      =>  true,
                                'color' => ['argb' => 'EB2B02'],
                            ],
    
                            //Set background style
                            'fill' => [
                                'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                                'startColor' => [
                                    'rgb' => 'dff0d8',
                                 ]           
                            ],
    
                        ]
                    );
                },
            ];
        }
    }