Laravel excel exports data, modifies the style of data, and processes data

Maatwebsite 3.1 edition excel export , Data pair , Style to handle , Record again

download laravel-excel, Download the latest version , Pay attention to whether the Framework version conforms to , The Framework version is low and can be downloaded 2.1

download

composer require maatwebsite/excel

Release configuration , It will add a config/excel.php file

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" --tag=config

establish App\Exports\UsersExport.php

<?php

namespace App\Exports;

use App\Models\User;// Import user table models class 
use App\Models\Motorcade;
use Dcat\Admin\Grid\Exporters\AbstractExporter;
use Illuminate\Support\Str;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use Maatwebsite\Excel\Concerns\WithPreCalculateFormulas;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\AfterSheet;
class UsersExport  extends AbstractExporter implements WithMapping, WithHeadings, FromCollection,WithColumnWidths,
WithPreCalculateFormulas,WithEvents
{
    
    use Exportable;
    protected $fileName = ' Driver data sheet ';// Export filename 
    protected $titles = [];// title 
     public function __construct()
    {
    
        $this->fileName = $this->fileName.'_'.Str::random(6).'.xlsx';// Splice download file name 
        $this->titles = ['id' => 'id','name'=>' Driver name ', 'car_id' => ' Team ' ,'created_at'=>' Creation time ','updated_at'=>' Update time '];
        parent::__construct();
    }

     public function export()
    {
    
        // TODO: Implement export() method.
        $this->download($this->fileName)->prepare(request())->send();
        exit;
    }


    public function collection()
    {
    
        // TODO: Implement collection() method.

        return collect($this->buildData());
    }
  public function headings(): array
    {
    
        // TODO: Implement headings() method.
        return $this->titles();
    }
    // Set width 
    public function columnWidths(): array
    {
    
    // Set row width 
        return [
            'A' => 15,
            'B' => 35, 
            'C' => 35,
            'D' => 35,
            'E' => 35,
        ];
    }
   // Custom add formula 
     public function registerEvents(): array
    {
    
        return [
            AfterSheet::class => function(AfterSheet $event) {
    
                
                $rows_line = $event->sheet->getHighestRow();// Get the current total number of data 
                $count = $rows_line+1;// Get the last line 
               
                $event->sheet->setCellValue("A$count","=SUM(A:A)");//  Set up A Column   The value of the last line , The value is A The sum of the columns 
            }
        ];
    }

public function map($row): array
    {
    
    // Data can be modified inside 
        $car = Motorcade::where('id',$row['car_id'])->first();
        $row['car_id'] = $car['name'];// modify  $row['car_id'] Value 

        // TODO: Implement map() method.
        return [
            $row['id'],
            $row['name'],
            $row['car_id'],
            $row['created_at'],
            $row['updated_at'],
        ];
    }



}

Introduce

use App\Exports\UsersExport;


$grid->export(new UsersExport());

Exported data