导出到excel

导出成excel下载到本地

批量将表数据导出成excel下载到本地，在laravel使用第三方插件库来完成此项工作

插件库：https://packagist.org/packages/maatwebsite/excel

官网: https://docs.laravel-excel.com/3.1/getting-started/

导出步骤：https://docs.laravel-excel.com/3.1/exports/

安装对应的phpexcel插件

composer require maatwebsite/excel=3.1

安装成功后，就会给我们提供生成导出数据的命令，使用命令生成导出文件

php artisan make:export FangOwnerExport --model=Models/FangOwner

下面是官方文档的给的相关例子:

The file can be found in app/Exports:

.
├── app
│   ├── Exports
│   │   ├── UsersExport.php
│ 
└── composer.json

If you prefer to create the export manually, you can create the following in app/Exports:

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::all();
    }
}

🔥 In your controller you can call this export now:

<?php

namespace App\Http\Controllers;

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;

class UsersController extends Controller 
{
    public function export() 
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
}

And finally add a route to be able to access the export:

Route::get('users/export/', 'UsersController@export');

📄 Find your users.xlsx in your downloads folder!