PHP 简易输出CSV表格文件

$ret = '';
$arrs = array(array(1,'test1'),
             array(2,'test2'),
             array(3,'test3'),
             array(4,'test4'),
             array(5,'test5'),
             array(6,'test6'),
             array(7,'test7')
            );
foreach($arrs as $k=>$arr){
    $ret .= $arr[0].",".$arr[1]." \n";
}
//$ret = @mb_convert_encoding ($ret, 'GBK','UTF-8');
header("Content-Disposition: attachment; filename=xxxx.csv");
header("Content-Type:APPLICATION/OCTET-STREAM");
$bomHeader = pack('H*','EFBBBF');   //将bom头转换二进制放在所有字符顶部,可以解决office Excel打开是乱码的问题
echo $bomHeader.$ret;

 

posted @ 2013-06-03 09:27  ﹏Sakura  阅读(452)  评论(0编辑  收藏  举报