laravel Excel 导入

<?php 
namespace AppModulesLiveHttpControllers;

use IlluminateHttpRequest;
use MaatwebsiteExcelFacadesExcel;
class ImportController extends Controller
{
    public function import(){
        try {
            
            $request = request();
            $file = $request->file("file");
            $originalName = $file->getClientOriginalName(); // 文件原名
            $realPath = $file->getRealPath();
            Excel::load($realPath, function($reader) use($file){
                $data = $reader->getSheet(0)->toArray();
                foreach($data as $key => $value){
                    if($key !=0){
                        $tmp['realname']=$value[0];
                        $tmp['mobile']=$value[1];
                        $tmp['idcard']=$value[2];
                        $tmp['passport']=$value[3];
                        $tmp['company_name']=$value[4];
                        $tmp['uniacid']=4;
                        $tmp['created_at']=time();
                        User::create($tmp);
                    }
                }
            });
            $this->_addLog('导入数据');
            return $this->result(0,'导入成功',['redirect' => wgRoute('member.index')]);
        }catch(Exception $e){
            return $this->error($e);
        }
    }
}
?>

如果需要在导入Excel数据中传递其他参数，可通过use()方法，以数组的形式进行传递

Excel::load($realPath, function($reader) use($options){}