php导出excel

最简单的例子:

<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls"); 

header("Pragma: no-cache");
header("Expires: 0");
echo "1/t2/t3/t4/t/n";
echo "11/t22/t33/t44/t/n";
?>

<?php

$file_type = "vnd.ms-excel";
$file_ending = "xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=export_file.$file_ending");
header("Pragma: no-cache");
header("Expires: 0");
$sql="select * from table  where ..;
$dbresult=dbx_query($db_link,$sql);
$sep = "/t";
$name[0]="收据编号";
$name[1]="收款人";
$name[2]="备注";
$name[3]="付款方式";
$name[4]="金额";
$name[5]="日期";
for ($i = 0; $i <6; $i++) {
echo $name[$i] . "/t";
}
print("/n");
for($for_index=0;$for_index<$dbresult->rows;$for_index++){
  $schema_insert = "";
  $tpl_shoujuhao=$dbresult->data[$for_index][0];
  $tpl_shoukuansid=$dbresult->data[$for_index][1];  
  $tpl_mark=$dbresult->data[$for_index][2];  
  $tpl_paytype=$dbresult->data[$for_index][3];             
 

 $tpl_mark=iconv("utf-8","gb2312",$tpl_mark);//将utf-8转换为gb2312

  for($j=0; $j<6;$j++){
   if($dbresult->data[$for_index][$j]!=""){
    if($j==0){
     $schema_insert .= $tpl_shoujuhao.$sep;
    }
    else if($j==1){
     $schema_insert .= $tpl_shoukuan.$sep;
    }
    else if($j==2){
     $schema_insert .= $tpl_mark.$sep;
    }
    else if($j==3){
     $schema_insert .= $tpl_show_paytype.$sep;
    }
  }
   else $schema_insert .= "".$sep;
  }
  $schema_insert = str_replace($sep."$", "", $schema_insert);
  $schema_insert .= "/t";
  print(trim($schema_insert));
  print "/n";
}
exit;
?>