public static function saveExcel($objPHPExcel, $excelName, $output) {
$objWriter = PHPExcel_IOFactory::createWriter ( $objPHPExcel, 'Excel5' );
if (! strpos ( $_SERVER ['HTTP_USER_AGENT'], 'Firefox' ))
$excelName = urlencode ( $excelName );
if ($output) {
ob_end_clean ();
header ( "Content-Type: application/force-download" );
header ( "Content-Type: application/octet-stream" );
header ( "Content-Type: application/download" );
header ( "Content-Disposition: attachment; filename=" . $excelName . ".xls" );
header ( "Content-Transfer-Encoding: binary" );
header ( "Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header ( "Last-Modified: " . gmdate ( "D, d M Y H:i:s" ) . " GMT" );
header ( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
header ( "Pragma: no-cache" );
$objWriter->save ( 'php://output' );
} else {
$objWriter->save ( "Excel/" . $excelName . ".xls" );
echo '<script language="javascript" type="text/javascript">window.top.window.stopUpload(1);</script>';
}
}
摘自 lpdx111的專欄