Yii2 Excle电子表格调出

    public function actionUserexcle(){
    	$get = trim(Yii::$app->request->get('strat',0));
    	$num = Yii::$app->request->get('strat',0);
       $strat = empty($get)?0:trim($num);
        // 根据id查询要导出的数据
        $asql="SELECT count(*) as count FROM member where id>=".$strat;
        $asum = Yii::$app->db->createCommand($asql)->queryOne();
        //条数和条数的计算
        $count = 10000;
        if($asum['count']-$count<$count){
            $count = $asum['count'];
        }
       if($count==0){
            return $this->redirect('/users/user/unlocked-user-list');
       }
        $db=new Query();
        $res=$db->select('m.*,p.qq,w.money')->from('member m')
             	  ->leftJoin('member_profile p','m.id=p.uid')
             	  ->leftJoin('member_wealth w','w.uid=m.id')
             	  ->where(['>=','m.id',$strat])
             	  ->limit($count)
             	  ->all();
        $name = $res[0]['id'].'-'.$res[$count-1]['id'].'_'.count($res);
        Header("Content-type: application/octet-stream ");
        Header("Accept-Ranges: bytes ");
        header("Content-type:application/vnd.ms-excel;charset=UTF-8");
        Header("Content-Disposition:attachment;filename=$name.xls ");
        $md = new Member(); //引入model层数据库
        $key = $md->attributeLabels();
        echo 'uid'.chr(9);
        echo '用户名'.chr(9);
        echo '真实姓名'.chr(9);
        echo '账户余额'.chr(9);
        echo '手机号'.chr(9);
        echo '邮箱'.chr(9);
        echo 'qq'.chr(9);
        echo '注册时间'.chr(9);
        echo chr(13);
        foreach ($res as $k=>$v){
            $v['created'] = date("Y-m-d H:i:s", $v['created']);
            echo $res[$k]['id'].chr(9);
            echo $res[$k]['username'].chr(9);
            echo $res[$k]['realname'].chr(9);
            echo $res[$k]['money'].chr(9);
            echo $res[$k]['phone'].chr(9);
            echo $res[$k]['email'].chr(9);
            echo $res[$k]['qq'].chr(9);
            echo $v['created'].chr(9);
            echo chr(13);
        }
        return true;
   }