public function getClassbalancesheet()
{
\Excel::create('Class Balance Sheet', function ($excel) {
$excel->sheet('Sheetname', function ($sheet) {
// first row styling and writing content
$sheet->mergeCells('A1:W1');
$sheet->row(1, function ($row) {
$row->setFontFamily('Calibri');
$row->setFontSize(20);
$row->setFontWeight('bold');
});
$sheet->row(1, array('Monthly Balance Sheet for Class'));
// second row styling and writing content
// $sheet->row(2, function ($row) {
// // call cell manipulation methods
// $row->setFontFamily('Comic Sans MS');
// $row->setFontSize(15);
// $row->setFontWeight('bold');
// });
// $sheet->row(2, array('Something else here'));
// getting data to display - in my case only one record
$users = Feedetails::get()->toArray();
// setting column names for data - you can of course set it manually
$sheet->appendRow(array_keys($users[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 ($users as $user) {
$sheet->appendRow($user);
}
});
})->export('xls');
}
