Laravel 加载Maatwebsite\Excel 3.1方法
1,composer.json 中require 添加
“maatwebsite/excel”: “~3.1”
composer update
或者直接运行 :
composer require maatwebsite/excel
2,config/app.php
打开config/app.php文件
添加以下代码
‘providers’ => [
Maatwebsite\Excel\ExcelServiceProvider::class,
]
‘aliases’ => [
‘Excel’ => Maatwebsite\Excel\Facades\Excel::class,
],
2,php artisan vendor:publish
将会自动创建一个新配置文件config/excel.php
3、php artisan make:export ExportDemo
将会自动创建一个新文件app/Exports/ExportDemo.php
代码示例:
<?php
namespace App\Exports;
use Maatwebsite\Excel\Concerns\FromCollection;
class ExportDemo implements FromCollection
{
private $row;
private $data;
public function __construct($row, $data)
{
$this->row = $row;
$this->data = $data;
}
public function collection()
{
$row = $this->row;
$data = $this->data;
//设置表头
foreach ($row[0] as $key => $value) {
$key_arr[] = $key;
}
//输入数据
foreach ($data as $key => &$value) {
$js = [];
try {
for