为什么80%的码农都做不了架构师?>>>
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
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');}
}