php生成EXCEL文件

最新推荐文章于 2024-09-11 11:00:10 发布

chenhang21367

最新推荐文章于 2024-09-11 11:00:10 发布

阅读量609

点赞数

分类专栏： php 文章标签： excel php include mysql header sql

本文链接：https://blog.csdn.net/chenhang21367/article/details/1596240

版权

php 专栏收录该内容

3 篇文章

订阅专栏

<?
header('Content-Type:application/vnd.ms-excel');
header("Content-Disposition:filename=test.xls");
include_once('tbs_class.php') ;
include_once('tbs_plugin_html.php');
include_once('config.php') ;
include_once('function.php') ;
$conn=linkDateBase($datebase);
$sql = "SELECT * FROM area order by id";
$result = mysql_query($sql,$conn) or die("SELECT Error:2 : " . mysql_error($conn));
echo iconv("utf-8","gb2312","编号/t");
echo iconv("utf-8","gb2312","区域/t/n");
while ($row = mysql_fetch_assoc($result)){
echo iconv("utf-8","gb2312",$row["id"]."/t");/
echo iconv("utf-8","gb2312",$row["name"]."/t/n");
}
?>