使用扩展包 /Laravel-Excel
1.安装
2.使用
//构造数据 $data = []; $data[0] = ['玩家ID','账号','昵称','描述','类型','金额','参数','记录时间']; $i=1; foreach ($actions as $u){ $data[$i][] = $u->role->UserID; $data[$i][] = $u->role->AccountName; $data[$i][] = $u->role->NickName; $data[$i][] = $u->Info; $data[$i][] = $u->getLogTypeDesc(); $data[$i][] = $u->TypeSum; $data[$i][] = $u->Param; $data[$i][] = $u->LogTime; $i++; } Excel::create('玩家货币流水',function($excel) use ($data){ $excel->sheet('cur', function($sheet) use ($data){ $sheet->rows($data); }); })->export('xls');