public function adminCsvAction() { $repository = $this->getDoctrine()->getRepository('AcmeTestBundle:Test'); $query = $repository->createQueryBuilder('s'); $query->orderBy('s.id', 'DESC'); $data = $query->getQuery()->getResult(); $filename = "export_".date("Y_m_d_His").".csv"; $response = $this->render('AcmeTestBundle:Default:adminCsv.html.twig', array('data' => $data)); $response->setStatusCode(200); $response->headers->set('Content-Type', 'text/csv'); $response->headers->set('Content-Description', 'Submissions Export'); $response->headers->set('Content-Disposition', 'attachment; filename='.$filename); $response->headers->set('Content-Transfer-Encoding', 'binary'); $response->headers->set('Pragma', 'no-cache'); $response->headers->set('Expires', '0'); $response->prepare(); $response->sendHeaders(); $response->sendContent(); return $response; }