Laravel扩展包下载excel

composer require maatwebsite/excel 默认安装最新得版本，下面我使用得是2.1版本的

 

在config/app.php中注册服务提供者到providers数组：

Maatwebsite\Excel\ExcelServiceProvider::class,

 

同样在config/app.php中注册门面到aliases数组：

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

 

如果想要对Laravel Excel进行更多的自定义配置，执行如下Artisan命令：

php artisan vendor:publish

 

 

例：

然后在routes.php中定义相关路由：

Route::get('excel/export','ExcelController@export'); Route::get('excel/import','ExcelController@import');

 

<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Http\Requests; use App\Http\Controllers\Controller; use Excel; class ExcelController extends Controller { //Excel文件导出功能 By Laravel学院 public function export(){ $cellData = [ ['学号','姓名','成绩'], ['10001','AAAAA','99'], ['10002','BBBBB','92'], ['10003','CCCCC','95'], ['10004','DDDDD','89'], ['10005','EEEEE','96'], ]; Excel::create('学生成绩',function($excel) use ($cellData){ $excel->sheet('score', function($sheet) use ($cellData){ $sheet->rows($cellData); }); })->export('xls'); } }

访问路由即可导出excel文件