php不使用插件导出excel的简单方法

2020-03-22 16:42:19

字体：大中小

来源：转载

供稿：网友

复制代码代码如下:
$filename=date("Y年m月d日")."数据信息统计结果.xls"; //文件名
$ua = $_SERVER["HTTP_USER_AGENT"]; //中文文件名不乱码
if (preg_match("/MSIE/", $ua)) {
$filename=urlencode($filename);
} else if (preg_match("/Firefox/", $ua)) {
$filename=$filename;
} else {
$filename=urlencode($filename);
}
header("Content-type:application/vnd.ms-excel"); //输出excel头
header("Content-Disposition:filename=".$filename);
$n = iconv('utf-8', 'gbk', '11'); //设置excel表格列
$t = iconv('utf-8', 'gbk', '22');
$k = iconv('utf-8', 'gbk', '33');
$s = iconv('utf-8', 'gbk', '44');
$r= iconv('utf-8', 'gbk', '55');
$a= iconv('utf-8', 'gbk', '66');echo "{$n}/t";
echo "{$t}/t";
echo "{$k}/t";
echo "{$s}/t";
echo "{$r}/t";
echo "{$a}/t/n";
foreach($a as $kk= $pp){ //对每列些数据
foreach($pp['child'] as $k= $p){
echo iconv("utf-8", "gbk//IGNORE", $pp['u']."/t");
echo iconv("utf-8", "gbk//IGNORE", $p['u']."/t");
echo iconv("utf-8", "gbk//IGNORE", $p['s']."/t");
echo iconv("utf-8", "gbk//IGNORE", $p['t']."/t");
echo iconv("utf-8", "gbk//IGNORE", $p['c']."/t");
echo iconv("utf-8", "gbk//IGNORE", $p['t']."/t/n");
}
}
数组格式为
复制代码代码如下:
Array
(
[0] = Array
(
[unitid] = 1234
[u] = aaa
[fid] = 1000
[shengid] = 1000
[shiid] = 0
[xianid] = 0
[rid] = 2
[orders] = 50
[sys_createuid] = 1
[sys_createtime] = 1383556976
[sys_updateuid] = 1
[sys_updatetime] = 1389853763
[child] = Array
(
[0] = Array
(
[unitid] = 1035
[u] = bbb
[fid] = 1000
[shengid] = 1000
[shiid] = 0
[xianid] = 0
[rid] = 2
[orders] = 50
[sys_createuid] = 1
[sys_createtime] = 1383556976
[sys_updateuid] = 1
[sys_updatetime] = 1389853763
[funitname] =
[s] = 6
[t] = 1
[c] = 1
[t] = 2
)
[4] = Array
(
[u] = 合计
[s] = 8
[t] = 1
[c] = 3
[t] = 3
))))
PHP教程

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。

上一篇：php通过pecl方式安装扩展的实例讲解php技巧

下一篇：php实现图片转换成ASCII码的方法