function onGenerateExcel() {

 try{

$items = post();
        $record_id=$items['id'];
        $queries = Db::table('trip')
        ->select('trip.id as trips_id','trip.unique_id as unique_id','trip.date_start as date_start','trip.date_end as date_end','products_orders.status as status', 'uemura_locations_cities.city_name as city_name','users.name as names','products_orders.invoice_number as invoice_number','trip.created_at as created_at')
        ->leftJoin('users', 'trip.user_id', '=', 'users.id')
        ->leftJoin('uemura_locations_cities', 'trip.city_id', '=', 'uemura_locations_cities.id')
        ->leftJoin('products_orders', 'trip.id', '=', 'products_orders.trip_id')
        ->where('trip.id', '=', $record_id)
        ->get();

//print_r($queries); die('okay');

         foreach($queries as $data) {
           $tripid = $data->trips_id;
           $uniqueid = $data->unique_id;
           $datestart = $data->date_start;
           $dateend = $data->date_end;
           $status = $data->status;
           $cityname = $data->city_name;
           $names = $data->names;
           $invoicenumber = $data->invoice_number;
           $createdat = $data->created_at;

                                    }

                    $data = [
                       'trips_id' => $tripid,
                       'unique_id' => $uniqueid,
                       'date_start' => $datestart,
                       'date_end' => $dateend,
                       'status' => $status,
                       'city_name' => $cityname,
                       'names' => $names,
                       'invoice_number' => $invoicenumber,
                       'created_at' => $createdat
                       ];

                 $excel->sheet('Sheet', function($sheet) {

                   $sheet->fromModel($data);

                        });

}

catch (Exception $e) { Flash::error($e->getMessage()); }

}

Depends on what you want to do, it's not clear for me. More details you can find on http://www.maatwebsite.nl/laravel-excel/docs

i m using in components

on this i get the id on the behalf of id i put join condition and fetch all data after data in controller i put this code <?php namespace watchlearn\travelinvoice\components;

use Cms\Classes\ComponentBase; use Input; use Validator; use Redirect; use Flash; use DB; use Renatio\DynamicPDF\Classes\PDF; use Vdomah\Excel\Classes\Excel; class Travelinvoice extends ComponentBase

{

public function componentDetails(){

        return[

          'name'=> 'Travelinvoice',

          'Description'=> 'Travelinvoice'

        ];  

}

public function onGenerateExcel() {

 try{

$items = post();
        $record_id=$items['id'];
        $queries = Db::table('trip')
        ->select('trip.id as trips_id','trip.unique_id as unique_id','trip.date_start as date_start','trip.date_end as date_end','products_orders.status as status', 'uemura_locations_cities.city_name as city_name','users.name as names','products_orders.invoice_number as invoice_number','trip.created_at as created_at')
        ->leftJoin('users', 'trip.user_id', '=', 'users.id')
        ->leftJoin('uemura_locations_cities', 'trip.city_id', '=', 'uemura_locations_cities.id')
        ->leftJoin('products_orders', 'trip.id', '=', 'products_orders.trip_id')
        ->where('trip.id', '=', $record_id)
        ->get();

//print_r($queries); die('okay');

         foreach($queries as $data) {
           $tripid = $data->trips_id;
           $uniqueid = $data->unique_id;
           $datestart = $data->date_start;
           $dateend = $data->date_end;
           $status = $data->status;
           $cityname = $data->city_name;
           $names = $data->names;
           $invoicenumber = $data->invoice_number;
           $createdat = $data->created_at;

                                    }

                    $data = [
                       'trips_id' => $tripid,
                       'unique_id' => $uniqueid,
                       'date_start' => $datestart,
                       'date_end' => $dateend,
                       'status' => $status,
                       'city_name' => $cityname,
                       'names' => $names,
                       'invoice_number' => $invoicenumber,
                       'created_at' => $createdat
                       ];
    Excel::excel()->load(base_path() . '/storage/app/media/file.xlsx', function($data) {

                $results = $data->all();

});

}

catch (Exception $e) { Flash::error($e->getMessage()); }

}

but it give me nothing