PHP 生成excel文件

<?php
function createtable($list,$filename){ 
    header("Content-type:application/vnd.ms-excel");
    header("Content-Disposition:attachment;filename=".$filename.".xls");
    
    $strexport="编号\t姓名\t性别\t年龄\r";
    foreach ($list as $row){
        $strexport.=$row['id']."\t";
        $strexport.=$row['username']."\t";
        $strexport.=$row['sex']."\t";
        $strexport.=$row['age']."\r";
    }
    $strexport=iconv('UTF-8',"GB2312//IGNORE",$strexport);
    exit($strexport);
}

$filename = '报表'.date('YmdHis');
$list = array(
    array('id'=>1,'username'=>'吴者然','sex'=>'男','age'=>27),
    array('id'=>2,'username'=>'景临境','sex'=>'男','age'=>29),
    array('id'=>3,'username'=>'暴天明','sex'=>'男','age'=>28),
    array('id'=>4,'username'=>'落月清','sex'=>'女','age'=>26)
);
createtable($list,$filename);

 

效果图：