laravel导出文件

//安装类包
composer require "maatwebsite/excel:~2.1.0"

<?php
namespace App\Http\Controllers\Admin;

use Maatwebsite\Excel\Facades\Excel;//使用类

class UserController extends Controller
{
	 public function csv(){
        $data = Users::all()->toArray();//获取所有数据
        return Excel::create('用户数据', function ($excel) use ($data) {//文件名
            $excel->sheet('用户数据', function ($sheet) use ($data) {//sheet名
                $sheet->cell('A1', function ($cell) {//给第一列固定值表头
                    $cell->setValue('ID');
                });
                $sheet->cell('B1', function ($cell) {
                    $cell->setValue('账户名');
                });
                $sheet->cell('C1', function ($cell) {
                    $cell->setValue('电话');
                });
                $sheet->cell('D1', function ($cell) {
                    $cell->setValue('邮箱');
                });
       if (!empty($data)) {
           foreach ($data as $key => $value) {
                  $i = $key + 2;//从第二行开始
                  $sheet->cell('A' . $i, $value['id']);
                  $sheet->cell('B' . $i, $value['account_number']);
                  $sheet->cell('C' . $i, $value['phone']);
                  $sheet->cell('D' . $i, $value['email']);
              }
          }
      });
        })->download('xlsx');
    }
}