php导出Excel文件简单的方法(非PHPEXCEL)

来源:互联网 发布:手机信号防干扰软件 编辑:程序博客网 时间:2024/05/18 02:38
function getExcel($key,$data,$fn='export_data.xls')        {            /*start export excel*/            $tline="\r\n";            $nx="";            header("Content-type:application/vnd.ms-excel");            header("Content-Disposition:attachment;filename=$fn");            header("Pragma: no-cache");            header("Expires: 0");            if($key)                foreach($key as $v){                    echo iconv("utf-8", "gb2312", $v).$nx;                }            if($data){                foreach($data as $i){                    echo  $tline;                    foreach(array_keys($key) as $ik){                        echo  iconv("utf-8", "gb2312", $i[$ik]).$nx;                    }                }            }            /* end export excel */            exit();        }<pre name="code" class="php">//数据格式$title=array('标题1','标题2','标题3');        $data=array(            array('tr1','tr11','tr111'),            array('tr2','tr22','tr222'),            array('tr3','tr33','tr333'),        );


0 0
原创粉丝点击