我用PHP5生成excel如下：<?phpheader("Content-type:application/vnd.ms-excel");header("Content-Disposition:filename=report.csv");echo "abc\t\bcd\t\n";echo "efg\t\hij\t\n";?>这在装Excel2000的客户端显示正常。而装Excel2003的客户端，却显示不正常。\t并不分格。请问有什么办法吗？
參考答案:<?php
ob_start();
define("FILETYPE","xls");
header("Content-type:application/vnd.ms-excel");
if(FILETYPE=="xls")
header("Content-Disposition:filename=report.xls");
else
header("Content-Disposition:filename=report.csv");
//逗号分隔值文件
/*
echo "姓名,年龄,性别\n";
//echo "efg\t\hij\t\n";
echo "张三,25,male";
echo "\n李四,27,male";
echo "\n王五,20,female";
*/
//xls file
echo "姓名\t年龄\t性别\n";
//echo "efg\t\hij\t\n";
echo "张三\t25\tmale";
echo "\n李四\t27\tmale";
echo "\n王五\t20\tfemale";
?>
要生成csv或xls自己修改define内的值就可以！
呵呵！要用xls！记得给分哦！
