Laravel 导出 Excel

使用命令行 用 composer 安装 maatwebsite/excel 执行以下代码

composer require maatwebsite/excel=~2.0

Package manifest generated successfully. 表示安装成功

打开config/app.php文件，添加以下代码

'providers' => [

        Maatwebsite\Excel\ExcelServiceProvider::class,

]

'aliases' => [

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

],

发布配置，请运行 vendor publish 命令：

php artisan vendor:publish

运行 vendor publish 命令后，会提示让你现在版本，我这里选择的是 8

Which provider or tag’s files would you like to publish?:
[0 ] Publish files from all providers and tags listed below
[1 ] Provider: BeyondCode\DumpServer\DumpServerServiceProvider
[2 ] Provider: Fideloper\Proxy\TrustedProxyServiceProvider
[3 ] Provider: Illuminate\Foundation\Providers\FoundationServiceProvider
[4 ] Provider: Illuminate\Mail\MailServiceProvider
[5 ] Provider: Illuminate\Notifications\NotificationServiceProvider
[6 ] Provider: Illuminate\Pagination\PaginationServiceProvider
[7 ] Provider: Laravel\Tinker\TinkerServiceProvider
[8 ] Provider: Maatwebsite\Excel\ExcelServiceProvider
[9 ] Tag: config
[10] Tag: laravel-errors
[11] Tag: laravel-mail
[12] Tag: laravel-notifications
[13] Tag: laravel-pagination
[14] Tag: stubs

将会自动创建一个新配置文件config/excel.php

调用方法 导出文件（ExcelController .php)

<?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 文件到处功能
 
 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');
 }
 
}

来源：https://blog.csdn.net/qq_25060761/article/details/123006554