public function getExportselected($id, Request $request) { Session::set('exportrec', $id); $excelnm = "category_" . date("d-m-Y"); Excel::create($excelnm, function ($excel) { $excel->sheet('Category', function ($sheet) { $sheet->mergeCells('A1:W1'); $sheet->row(1, function ($row) { $row->setFontFamily('Comic Sans MS'); $row->setFontSize(30); }); $sheet->row(1, array('Category Report')); $sheet->row(2, function ($row) { $row->setFontFamily('Comic Sans MS'); $row->setFontSize(15); $row->setFontWeight('bold'); }); $sheet->row(2, array('Category Details')); /* getting data to display - in my case only one record */ $ids = Session::get('exportrec'); $newdatas = explode(",", $ids); $gdatalist = $this->category_gestion->getallrecords($newdatas); $dataArr = array(); if (is_array($gdatalist) && count($gdatalist) > 0) { $counter = 0; foreach ($gdatalist as $kyy => $dataval) { $dataArr[$counter]['Sl'] = $counter + 1; $dataArr[$counter]['Category'] = $dataval['name']; $dataArr[$counter]['Slug'] = $dataval['category_slug']; $dataArr[$counter]['Date'] = $dataval['updated_at']; $counter++; } } /* setting column names for data - you can of course set it manually */ $sheet->appendRow(array_keys($dataArr[0])); /* column names */ /* getting last row number (the one we already filled and setting it to bold */ $sheet->row($sheet->getHighestRow(), function ($row) { $row->setFontWeight('bold'); }); /* putting users data as next rows */ foreach ($dataArr as $user) { $sheet->appendRow($user); } }); })->export('xls'); }