/** * Sheet data row * * @param LaravelExcelWorksheet $sheet * @param int $index * @param Project\Issue $issue * * @return void */ protected function sheetRow(LaravelExcelWorksheet $sheet, $index, Project\Issue $issue) { // Setup row data array_walk($this->columns, function (&$column, $key, Project\Issue $issue) { $column = (string) $issue->{$key}; if ($key === 'status') { $column = (int) $issue->status === Project\Issue::STATUS_OPEN ? 'open' : 'closed'; $column = trans('tinyissue.' . $column); } }, $issue); // Write row $sheet->row($index, $this->columns); // Format last cell $sheet->cell('G' . $index, function (CellWriter $cell) use($issue) { $color = (int) $issue->status === Project\Issue::STATUS_CLOSED ? '#FF0000' : '#00FF00'; $cell->setBackground($color); }); }