header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=".$filename.".xls");//$filename 导出文件名;
查询条件
echo 内容."\t"; //写数据到excel文件的列中;
echo 内容."\t"; //写数据到excel文件的列中;
echo 内容."\t"; //写数据到excel文件的列中;
echo 内容."\t\n"; //写数据到excel文件的列中并换行;


其实把内容输出成
"3","lalaa","a","2003-08-25 16:08:13"
"3","lalaa","a","2003-08-25 16:08:13"
"3","lalaa","a","2003-08-25 16:08:13"
"3","lalaa","a","2003-08-25 16:08:13"
这样一行一行di,然后保存文件的扩展名为.csv,excel就可以读取啦。哈哈哈哈