1、在laravel根目录下面打开composer.json文件并引入Excel如图
2、执行composer install
3、打开config下面的app.php中修改如下: 在providers 中加上 Maatwebsite\Excel\ExcelServiceProvider::class 在aliases 中加上“Excel” => Maatwebsite\Excel\Facades\Excel::class
'providers' => [Maatwebsite\Excel\ExcelServiceProvider::class]
'Excel' => Maatwebsite\Excel\Facades\Excel::class,
4、在项目根目录的位置运行下面命令
php artisan vendor:publish
5、定义路由指向如下方法即可导出Excel
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Excel;
class ExcelController extends Controller
{
public function export(){
$cellData = [
['学号','姓名','年龄','成绩','名次'],
['10001','张三',19,100,1],
['10002','李四',18,90,2]
];
Excel::create("学生成绩",function ($excel) use ($cellData){
$excel->sheet('score',function ($sheet) use ($cellData) {
$sheet->rows($cellData);
});
})->export('xls');
}
}