在 vendor/yiisoft/yii2/helpers/ 创建一个 Excel.php
<?php
namespace yii\helpers;
class Excel{
public static function down_xls($data,$keys){
$xls="<html><meta http-equiv=content-type content=\"text/html;charset=UTF-8\"><body><table border='1'>";
$xls.="<tr><td>".implode("</td><td>",$keys)."</td></tr>";
$xls.=implode("",array_map(function($x){
return '<tr><td>'.implode("</td><td>",$x).'</td></tr>'
},$data));
$xls.="</table></body></html>";
header("Content-Type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename='".uniqid().".xls'");
die($xls);
}
}
?>
任意控制器下:
use yii\helpers\Excel;
Excel::down_xls(查询出来的数据{二维数组},标题{一维数组});