海量excel数据导出方案解决 xlswriter性能测试

public function test(Request $request)
    {
        $start_time = date(‘Y-m-d H:i:s‘);

        ini_set(‘memory_limit‘, ‘1024m‘);
        $config = [
            ‘path‘ => public_path() . ‘/upload‘ // xlsx文件保存路径
        ];
        $excel = new Excel($config);

        $textFile = $excel->fileName("free.xlsx")->header([‘id‘, ‘name‘, ‘phone‘, ‘source‘, ‘province_name‘, ‘city_name‘, ‘data_time‘, ‘user_id‘, ‘user_nickname‘, ‘register_time‘, ‘up_user_id‘, ‘store_name‘, ‘is_pull_new‘]);
        //大约11万数据
        foreach (BrokerMemberData::get() as $k => $v) {

            $textFile->insertText($k+1, 0, $v->id);
            $textFile->insertText($k+1, 1, $v->name);
            $textFile->insertText($k+1, 2, $v->phone);
            $textFile->insertText($k+1, 3, $v->source);
            $textFile->insertText($k+1, 4, $v->province_name);
            $textFile->insertText($k+1, 5, $v->city_name);
            $textFile->insertText($k+1, 6, $v->data_time);
            $textFile->insertText($k+1, 7, $v->user_id);
            $textFile->insertText($k+1, 8, $v->user_nickname);
            $textFile->insertText($k+1, 9, $v->register_time);
            $textFile->insertText($k+1, 10, $v->up_user_id);
            $textFile->insertText($k+1, 11, $v->store_name);
            $textFile->insertText($k+1, 12, $v->is_pull_new);
        }

        $filePath = $textFile->output();

        p(BrokerMemberData::count());
        p(‘执行成功 开始时间‘ . $start_time . ‘结束时间‘ . date(‘Y-m-d H:i:s‘));
        p($filePath);
    }