XLSXWriter::writeSheet PHP Method

    public function writeSheet(array $data, $sheet_name = '', array $header_types = array())
    {
        $sheet_name = empty($sheet_name) ? 'Sheet1' : $sheet_name;
        $data = empty($data) ? array(array('')) : $data;
        if (!empty($header_types)) {
            $this->writeSheetHeader($sheet_name, $header_types);
        }
        foreach ($data as $i => $row) {
            $this->writeSheetRow($sheet_name, $row);
        }
        $this->finalizeSheet($sheet_name);
    }

 static function xls()
 {
     return function ($req, $res, $svc, $app) {
         $time = date('H:i:s', time());
         $date = date('d-m-Y');
         $exportFile = __DIR__ . "/../xls/relatorio-tickets-{$time}.xlsx";
         $headers = [['Protocolo', 'Operadora', 'Status', 'Cidade', 'Problema', 'Designação', 'Cliente Final', 'Data']];
         $rows = array_map(function ($ticket) {
             return [$ticket->protocolo, $ticket->operadora, $ticket->status, $ticket->cidade, $ticket->tipo_problema, $ticket->designacao, $ticket->cliente_final, date('d/m/Y', strtotime($ticket->criado_em))];
         }, Tickets::filter($req, $app));
         $writer = new \XLSXWriter();
         $writer->writeSheet(array_merge($headers, $rows), 'Relatório ' . $date);
         $writer->setAuthor('Sim TV - Trouble Ticket');
         $writer->writeToFile($exportFile);
         $res->file($exportFile, "Relatório Tickets {$time}.xlsx");
     };
 }