Route::get('loadexcel',function(){ $res = []; Excel::load('1.xls', function($reader) use( &$res ) { $reader = $reader->getSheet(0);//得到Excel的第一个sheet $res = $reader->toArray();//转换为数组,0就是第一行(标题),二维数组 }); foreach ($res as $key=>$data){ if($key == 0){ continue;//0是标题呀 } //去取出需要的数据 $time = $data[0]; $dingdan = $data[1]; $money = $data[4]; $userid = json_decode($data[9])->userid; $gold = 0; switch ($money){ case 10: $gold = 90000; break; case 50: $gold = 460000; break; case 100: $gold = 950000; break; case 500: $gold = 4900000; } $sql = "call AddLog('游戏服务器充值成功','operator',$userid,0,'$dingdan',0,0,$money,0,0,0,$gold,0,'$time',0,1)"; DB::select($sql); } return "导入成功"; });