php解决导出大数据execl问题

描述:在实际工作中,有时候我们需要导出大量数据到execl里面，可以参考分页方式导出，将每一页的数据放进php输出流里面 代码如下

<?php
    ini_set('memory_limit', '2048M'); 
    header('Content-Description: File Transfer');
    header('Content-Type: application/vnd.ms-excel');
    header('Expires: 0');
    header('Cache-Control: must-revalidate');
    header('Pragma: public');
    $filename ="111.xlsx";
    header("Content-Disposition:filename={$filename}");
    $fp = fopen("php://output",'a');
    $title = ["id", "name", "age","aa","bb"];

    $str = implode("\t",$title)."\n";
    fwrite($fp,$str,strlen($str));
    $bigData=[];
    for($i=0;$i<1000000;$i++){
        $tmp=[];
        $tmp["id"]=1;
        $tmp["name"]="lisi";
        $tmp["age"]=20;
        $tmp["aa"] = 20;
        $tmp["bb"] = 20;

        array_push($bigData,$tmp);
    }
   $result = array_chunk($bigData,5);
    for($i=0;$i