PHP匯出excil報表

PHP匯出excil表格

PHP匯出Excel格式檔案(xls),只需給PHP檔案加一個檔案頭,filename 就是匯出的xls檔案名稱,當你點擊這個檔案的URL時,就會提示你下載xls檔案了

header("Content-Type: application/vnd.ms-execl");
header("Content-Disposition: attachment; filename=info.xls");
header("Pragma: no-cache");
header("Expires:0");

例子：

header("Content-Type: application/vnd.ms-execl");

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

header("Pragma: no-cache");

header("Expires:0");

require_once(dirname(__FILE__)."/../include/config_base.php");

require_once(dirname(__FILE__)."/../dede/config.php");

require_once(dirname(__FILE__)."/../include/pub_datalist.php");

$dsql = new DedeSql(false);

echo "訂閱日期"."\t";

echo "訂閱內容"."\t";

echo "姓名"."\t";

$dsql->SetQuery("Select * from `TableName` order by `id` desc");

$dsql->Execute();

$i = 1;

while($row = $dsql->GetArray()){

echo $row['uTime']."\t";

echo $row['uCont']."\t";

echo $row['uName']."\t";

$i++;

}?>

2014-04-04

來自於百度空間 遷移

