public function downloadProjectWiseDetailedReport($sdate, $edate) { $timeEntryObj = new TimeEntry(); $timeEntries = $timeEntryObj->getProjectWiseDetailedReport($sdate, $edate); Excel::create('Timesheet_ProjectWise_Detailed_Report_' . time(), function ($excel) use($timeEntries) { //echo "ss<pre>";print_r($timeEntries);die; $data = []; foreach ($timeEntries as $entry) { $data[] = ['Date' => $entry->createdDate, 'Project Name' => $entry->projectName, 'Client Name' => $entry->clientName, 'Time' => $entry->time, 'Total Time' => $entry->totalTime, 'Team' => $entry->team]; } $excel->sheet('Sheet 1', function ($sheet) use($data) { $last_row = count($data) + 1; $sheet->fromArray($data); foreach ($data as $k => $v) { $row_num = $k + 2; if (empty($v['Time'])) { $sheet->row($row_num, function ($row) { // call cell manipulation methods $row->setBackground('#FFFF00'); }); $sheet->row($row_num, array($v['Date'], $v['Project Name'] . ' Total', $v['Client Name'], $v['Time'], $v['Total Time'], $v['Team'])); } $sheet->row($last_row, array('', 'Total', '', '', $v['Total Time'], '')); //Last row: total of all projects $sheet->row($last_row, function ($row) { // call cell manipulation methods $row->setBackground('#0000FF'); }); } }); })->download('xls'); }