php导出生成excel表格几种方法介绍

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=test_data.xls");

$tx=’表头’;  
echo   $tx."nn";  
//输出内容如下：  
echo   "姓名"."t";  
echo   "年龄"."t";  
echo   "学历"."t";  
echo   "n";  
echo   "张三"."t";  
echo   "25"."t";  
echo   "本科"."t";  
?>

function outputXlsHeader($data,$file_name = 'export')
{
 header('Content-Type: text/xls');
 header ( "Content-type:application/vnd.ms-excel;charset=utf-8" );
 $str = mb_convert_encoding($file_name, 'gbk', 'utf-8');   
 header('Content-Disposition: attachment;filename="' .$str . '.xls"');     
 header('Cache-Control:must-revalidate,post-check=0,pre-check=0');       
 header('Expires:0');        
 header('Pragma:public');
 
 $table_data = '

 foreach ($data as $line)        
 {
  $table_data .= '