php输出excel文件,php输出excel格式文件

//输出内容如下：

// 输出表头

echo iconv("utf-8", "gb2312", "客户名称")."t";

echo iconv("utf-8", "gb2312", "电话")."t";

echo iconv("utf-8", "gb2312", "地址")."t";

echo iconv("utf-8", "gb2312", "添加日期")."t";

echo "n"; //换行

$sqlstr = "select * from clients where usersid=32 order by clientsid desc";

$rows = $db -> select($sqlstr);

$num = count($rows); //客户总数

for( $i = 0; $i < $num; $i++ )

{

echo iconv("utf-8", "gb2312",$rows[$i][clientsname])."t";

echo iconv("utf-8", "gb2312",$rows[$i][clientsphone])."t";

echo iconv("utf-8", "gb2312",$rows[$i][clientsaddress])."t";

echo iconv("utf-8", "gb2312",$rows[$i][clientstime])."t";

echo "n"; //换行

}

?>