php导出excel的实例代码

<?
Header("Content-type:   application/octet-stream");
Header("Accept-Ranges:   bytes");
Header("Content-type:application/vnd.ms-excel");   
Header("Content-Disposition:attachment;filename=export_excel_gshjsl.xls");   
  
$tx='表头';
echo   $tx."\n\n";
echo   "编号"."\t";
echo   "姓名"."\t";
echo   "\n";
echo "=\"411481198507150666\""."\t";
echo "=\"0123456\""."\t"; //带上引号方便字符串输出。相当于设置单元格格式为文本。
echo "\n";
?>

<?php
/**
* php导出word文件
* site: www.jbxue.com
*/
header("Content-Type:   application/msword");       
header("Content-Disposition:   attachment;   filename=doc.doc");       
header("Pragma:   no-cache");       
header("Expires:   0");       

$output    =   '<table border="1" cellspacing="2" cellpadding="2" width="90%" align="center">';       
$output   .=   '<tr bgcolor="#cccccc"><td   align="center">图片</td></tr>';       
$output   .=   '<tr bgcolor="#f6f7fa"><td><span style="color:#FF0000;"><strong>下面是一张图片</strong></span></td></tr>';       
$output   .=   '<tr><td align="center"><img src=";       
$output   .=   '</table>';

echo   $output;       
?>

<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");
echo "A\tB\n";
echo "C\tD\n";
?>