php导出excel表格

控制器内

public function out()
 {
    $res = $this->incomes->selExcelIncome();
    $filename = '用户每日收支记录'.date('YmdHi');  
$header = array('用户id','收入金币','支出金币','收入奖券','支出奖券','收入钻石','支出钻石','支出人民币','录入时间');  
$index = array('user_id','income_coin','extend_coin','income_lottery','extend_lottery','income_gem','extend_gem','extend_rmb','create_time');  
createTable($res,$filename,$header,$index);  
  }

common.php 内

function createTable($list,$filename,$header=array(),$index = array())
{    
    header("Content-type:application/vnd.ms-excel");    
    header("Content-Disposition:filename=".$filename.".xls");    
    $teble_header = implode("\t",$header);  
    $strexport = $teble_header."\r";  
    foreach ($list as $row){    
        foreach($index as $val){  
            $strexport.=$row[$val]."\t";     
        }  
        $strexport.="\r";   

    }    
    $strexport=iconv('UTF-8',"GB2312//IGNORE",$strexport);    
    exit($strexport);       
}