导出成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!