php生成excel文件

<?php

require_once(dirname(
FILE).‘/inc/config.inc.php‘);

header("Content-type:application/vnd.ms-excel");

header("Content-Disposition:filename=volunteer.xls");

echo "ID\t";

echo "姓名\t";

echo "性别\t";

echo "志愿者服务时长\t";

echo "发布时间\t\n";

$dopage->GetPage("SELECT * FROM
#@__msg");

while($row = $dosql->GetArray())

{

echo $row[‘id‘]."\t";

echo $row[‘name‘]."\t";

echo $row[‘sex‘]."\t";

echo $row[‘fw‘]."\t";

echo $row[‘posttime‘]."\t\n";

}

?>

相关文章