如果要利用了php输出excel格式文件就必须利用header content-type:application/vnd.ms-excel来实现。如下
再看一php输出excel实例
select($sqlstr);
$num = count($rows); //客户总数
for( $i = 0; $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; //换行
}
?>
再来一款简单实例
header(content-type:application/vnd.ms-excel);
header(content-disposition:attachment;filename=users.xls );
echo 公司名称.t;
echo 用户名.t;
echo 密码.t;
echo 二级域名.t;
echo n;
foreach($result['result'] as $val){
echo $val->comname.t;
echo $val->username.t;
echo $val->usertruepw.t;
echo emptyempty($val->domainname)?'':('http://'.$val->domainname.'.jiaomai.com').t;
echo n;
}
http://www.bkjia.com/phpjc/630800.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/630800.htmltecharticlephp教程输出excel格式文件 如果要利用了php输出excel格式文件就必须利用header content-type:application/vnd.ms-excel来实现。如下 ?php $filename = name .'....