使用的phpoffice進(jìn)行表格的輸出
下面為使用方法：
public function excel(Request $request)
$behaviorDetail = 所查數(shù)據(jù)馅扣；
$newExcel = new Spreadsheet(); //創(chuàng)建一個(gè)新的excel文檔
$objSheet = $newExcel->getActiveSheet(); //獲取當(dāng)前操作sheet的對(duì)象
$objSheet->setTitle(''); //設(shè)置當(dāng)前sheet的標(biāo)題
//設(shè)置寬度為true,不然太窄了
$newExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$newExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$newExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$newExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objSheet->setCellValue('A1', '列名')
->setCellValue('B1', '列名')
->setCellValue('C1', '列名')
->setCellValue('D1', '列名');
foreach ($behaviorDetail as $k => $val) {
$k = $k + 2;
$objSheet->setCellValue('A' . $k, $val[''])
->setCellValue('B' . $k, $val[''])
->setCellValue('C' . $k, $val[''])辆沦；
}
$this->downloadExcel($newExcel, '表名', 'Xls');
}
function downloadExcel($newExcel, $filename, $format)
{
// $format只能為 Xlsx 或 Xls
if ($format == 'Xlsx') {
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
} elseif ($format == 'Xls') {
header('Content-Type: application/vnd.ms-excel');
}
header('Content-Disposition: attachment;filename="'
. $filename . date('Y-m-d', strtotime('-1 day')) . '.' . strtolower($format).'"');
header('Cache-Control: max-age=0');
$objWriter = IOFactory::createWriter($newExcel, $format);
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0
$objWriter->save('php://output');
exit;
}
