public function genExcel(LouisCRUD $crud, array $list, $filename = null)
{
// PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
$excel = new PHPExcel();
$sheet = $excel->getActiveSheet();
$fields = $crud->getShowFields();
// Header
$i = 0;
foreach ($fields as $field) {
$sheet->setCellValueByColumnAndRow($i, 1, $field->getDisplayName());
$sheet->getColumnDimensionByColumn($i)->setAutoSize(true);
$i++;
}
// Data
$j = 2;
foreach ($list as $bean) {
$i = 0;
foreach ($fields as $field) {
$sheet->getCellByColumnAndRow($i, $j)->setValueExplicit(strip_tags($field->cellValue($bean)));
$i++;
}
$j++;
}
// Save
$objWriter = new PHPExcel_Writer_Excel2007($excel);
//$rand = dechex(rand(0, 99999999));
if ($filename == null) {
$name = $crud->getTableName();
$date = date("Y-m-d", time());
$filename = "{$name}-{$date}.xlsx";
}
$headers = ['Content-Type' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'Content-Disposition' => 'attachment;filename="' . $filename . '"', 'Cache-Control' => 'max-age=0'];
foreach ($headers as $key => $value) {
$h = $this->headerClosure;
$h($key, $value);
}
$objWriter->save("php://output");
}
