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"); 

例子：

<?php

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

来自于百度空间  迁移