Laravel-Excel (MaatWebSite) 需要长篇阅读

Laravel-Excel（MaatWebSite）是一个功能强大的Laravel扩展包，它为我们提供了处理Excel文件的便捷方法。无论是导入数据还是导出数据，Laravel-Excel都能够轻松地满足我们的需求。本文将介绍Laravel-Excel的基本用法，并通过一个实例来演示其强大的功能。

bash
composer require maatwebsite/excel

php
Maatwebsite\Excel\ExcelServiceProvider::class,

php
'Excel' => Maatwebsite\Excel\Facades\Excel::class,

php
use Maatwebsite\Excel\Facades\Excel;
Excel::import(new UsersImport, 'users.xlsx');

php
use Maatwebsite\Excel\Concerns\FromCollection;
class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::all();
    }
}

php
use Maatwebsite\Excel\Facades\Excel;
Excel::store(new UsersExport, 'users.xlsx');

php
use Maatwebsite\Excel\Concerns\FromCollection;
use App\Models\User;
class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::all();
    }
}

php
use Maatwebsite\Excel\Facades\Excel;
Excel::store(new UsersExport, 'users.xlsx');

php
use Maatwebsite\Excel\Concerns\ToModel;
use App\Models\User;
class UsersImport implements ToModel
{
    public function model(array $row)
    {
        return new User([
            'name' => $row[0],
            'email' => $row[1],
            'password' => $row[2],
        ]);
    }
}

php
use Maatwebsite\Excel\Facades\Excel;
Excel::import(new UsersImport, 'users.xlsx');