snippet for csv export

export.php

<?
    /**
     * @param $queryData
     *
     * @return StreamedResponse
     */
    protected function _exportAsCsv($queryData)
    {
        $container = $this->container;
        $response = new StreamedResponse(
            function () use ($container, $queryData) {
                $handle = fopen('php://output', 'r+');
                $result = $this->_fetchReportingData($queryData);

                foreach ($result as $row) {
                    fputcsv($handle, $row);
                }

                fclose($handle);
            }
        );

        $filename = "export_" . date("Y_m_d") . ".csv";
        $d = $response->headers->makeDisposition(
            ResponseHeaderBag::DISPOSITION_ATTACHMENT,
            $filename
        );
        $response->headers->set('Content-Disposition', $d);
        $response->headers->set('Content-Type', 'application/octet-stream');
        $response->headers->set('Content-Type', 'text/csv');
        $response->headers->set('Mime-Type', 'text/csv');
        $response->headers->set("Pragma", "public");
        $response->headers->set("Expires", "0");
        $response->headers->set("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
        $response->headers->set("Cache-Control", "private");

        $response->prepare(Request::createFromGlobals());
        $response->sendHeaders();
        $response->sendContent();

        return $response;
    }