PHP导出CSV格式Excel文件的方法

本文主要介绍了PHP导出CSV格式Excel文件的方法，需要的朋友可以参考下

代码如下：

function export_csv($filename,$head,$data)   
{
    $header = array_values($head);
    $string = '';
    foreach ($header as $k=>$v){
        $string .= iconv('UTF-8"','GBK//IGNORE',$v). ','; //中文转码
    }
    $string = rtrim($string,',')."\n";
    $fields = array_keys($head);
    foreach ($data as $k=>$v){
        $str = '';
        foreach ($fields as $kk=>$vv){
            if(isset($v[$vv])){
                $str .= iconv('UTF-8"','GBK//IGNORE',$v[$vv]). ',';
            } else {
                $str .= '~,';
            }
        }
        $string .= rtrim($str,',')."\n";
    }
    header("Content-type:text/csv");
    header("Content-Disposition:attachment;filename=".$filename.".csv");
    header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
    header('Expires:0');
    header('Pragma:public');
    exit($string);
}