Laravel Excel

版本限制

Version 1	header 2	Php Version	Support
2.1	<=5.6	<=7.0	Unsupported since 15-5-2018
3.0	^5.5	^7.0	Unsupported since 31-12-2018
3.1	^5.8 ^6.0 ^7.0 ^8.0	^7.2 ^8.0	New features

安装

composer require maatwebsite/excel

#config/app.php

    'providers' => [
        /*
         * Package Service Providers...
         */
        Maatwebsite\Excel\ExcelServiceProvider::class,
    ]
    
    'aliases' => [
    ...
    'Excel' => Maatwebsite\Excel\Facades\Excel::class,
    ]

导出

数组导出

1.新建一个导出类

- 1
namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromArray;

class InvoicesExport implements FromArray
{
   
    public function array(): array
    {
   
        return [
            [1, 2, 3],
            [4, 5, 6