//$table=User::tableName();//获取表名 动态的表名,如{{%user}} $table = 'user_credit_info_img'; $result=UserCreditInfoImg::find()->all(); $columns=[];//储存字段 $header=[];//储存表格头部 $sql='show full columns from '.$table; $data=\Yii::$app->db->createCommand($sql)->queryAll(); foreach($data as $data_){ $columns[]=$data_['Field']; $header[$data_['Field']]=$data_['Comment']; } //调用PHPExcel导出数据 Excel::export([ 'models'=>$result, 'fileName'=>$table, 'columns'=>$columns, 'headers'=>$header, ]); echo '完成';