1、安装
composer require "maatwebsite/excel:~2.1.0"
2、在config/app.php中注册服务提供者到providers数组:
'Excel' => Maatwebsite\Excel\Facades\Excel::class,
3、在config/app.php中注册门面到aliases数组
'Excel' => Maatwebsite\Excel\Facades\Excel::class,
4、创建导入类
php artisan make:import CustomerTrademarkDiscountsImport
5、找到类文件,
namespace App\Imports;
use Maatwebsite\Excel\Concerns\ToArray;
class CustomerTrademarkDiscountsImport implements ToArray
{
public function array(array $array)
{
return $array;
}
}
6、执行导入文件
$data = Excel::toArray(new CustomerTrademarkDiscountsImport(), public_path('/data/discount20210820-1.xlsx'));
//$data为所有excel所有数据,可以使用处理