mercredi 19 décembre 2018

Error syntax laravel 5.7 maatwebsite/excel

I want to use maatwebsite/excel on laravel 5.7 and I'm currently stuck for some time on a syntax error, can you help me?

"syntax error, unexpected '}'" line 28 :

    <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use Excel;

class ExportExcelController extends Controller
{
    function Export()
    {
      $customer_data = DB::table('qualys')->get();
      return view('export_excel')->with('customer_data', $customer_data);
    }
    function excel()
    {
      $customer_data = DB::table('qualys')->get()->toArray();
      $customer_data[] = array('qid','ip');

      foreach($customer_data as $customer)
      {
         $customer_array[] = array(
                  'qid' => $customer -> qid,
                  'ip' => $customer -> ip
        )
      }
      Excel::create('customer data', function($excel) use ($customer_array)
      {
           $excel->setTitle('customer Data');
           $excel->sheet('Customer Data', function($sheet) use ($customer_array)
           {
             $sheet->fromeArray($customer_array, null, 'A1', false, false);
           });
      })->download('xlsx');
    }
}

Sincerely



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire