/**
* 创建下载excel表
* @param array $list 数据表
* @param text $filename 文件名 例:$filename = ‘报名名单（’.date(‘YmdHis’).’）’;
* @param text $header 列表头名称 例:$header = array(‘用户名’,’性别’);
* @param text $index 数据下标段 例:$index = array(‘name’,’sex’,’birthday’);
* @author xiaodai <408366645@qq.com>
*/
function createtableToExcel($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);
}

例子：

/**
*下载为Excel
*/
public function DownloadToExcel(){
$map[‘status’] = array(‘egt’,0);
$site = session(“site”);
$map[‘site_id’] = $site[‘id’];
$filename = ‘报名名单（’.date(‘YmdHis’).’）’;
$header = array(‘名称’,’组别’,’地区’,’联系人’,”联系人手机”,”报名时间”);
$index = array(‘fullname’,’education’,’address’,’emergency_name’,”emergency_phone”,”create_time”);
$model = D(“Signcctc”);
$list = $model->where($map)->select();

foreach ($list as $key => $value) {
foreach ($value as $k => $v) {
if($k==”create_time”){
$list[$key][$k]=date(‘Y-m-d H:i:s’, $list[$key][$k]);

}
}
}
//var_dump($list);
createtableToExcel($list,$filename,$header,$index);

}