超级好用的excel导出方法,比phpexcel快n倍,并且无乱码

 public  function exportToExcel($filename, $tileArray=[], $dataArray=[]){

        ini_set('memory_limit','512M');

        ini_set('max_execution_time',0);

        ob_end_clean();

        ob_start();

        header("Content-Type: text/csv");

        header("Content-Disposition:filename=".$filename);

        $fp=fopen('php://output','w');

        fwrite($fp, chr(0xEF).chr(0xBB).chr(0xBF));//转码 防止乱码(比如微信昵称(乱七八糟的))

        fputcsv($fp,$tileArray);

        $index = 0;

        foreach ($dataArray as $item) {

            if($index==1000){

                $index=0;

                ob_flush();

                flush();

            }

            $index++;

            fputcsv($fp,$item);

        }



        ob_flush();

        flush();

        ob_end_clean();

    }

 

posted @ 2018-10-22 15:45  王小默  阅读(517)  评论(0编辑  收藏