php 实现在线导出

$fileName = "竞猜活动开奖码发放记录-" . date("Ymd", time()) . rand(1000, 9999) . ".xls";
$headList = ["用户", "mc_openid", "开奖码", "类型", "是否中奖", "是否领取", "奖品", "姓名", "手机号", "地址", "获取时间"];
header("Content-Type: application/vnd.ms-execl");
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=$fileName");
header("Pragma: no-cache");
header("Expires: 0");
foreach ($headList as $head) {
    echo iconv("utf-8", "gb2312", $head)."\t";
}
echo "\n";

while (true) {
    if (empty($data)) {
        $search['limit'] = $pageSize;
        $search['offset'] += $pageSize;
        $data = $this->hnGuessCodeLogService->searchGuessCodeLogList($search);
    }
    if (!empty($data['data']['list'])) {
        foreach ($data['data']['list'] as $info) {
            echo iconv("utf-8", "gb2312", $info['uid']) ."\t";
            echo iconv("utf-8", "gb2312", $info['mc_openid']) ."\t";
            echo iconv("utf-8", "gb2312", $info['code']) ."\t";
            echo iconv("utf-8", "gb2312", $info['type']) ."\t";
            echo iconv("utf-8", "gb2312", $info['is_win']) ."\t";
            echo iconv("utf-8", "gb2312", $info['is_get']) ."\t";
            echo iconv("utf-8", "gb2312", $info['prize']) ."\t";
            echo iconv("utf-8", "gb2312", $info['name']) ."\t";
            echo iconv("utf-8", "gb2312", $info['phone']) ."\t";
            echo iconv("utf-8", "gb2312", $info['address']) ."\t";
            echo iconv("utf-8", "gb2312", $info['gmt_created']) ."\n";
        }
    }

    if (count($data['data']['list']) < $pageSize) {
        break;
    }
    $data = [];
}