欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

PHPExcel php execl下载或保存到本地_PHP教程

程序员文章站 2022-03-26 20:01:42
...
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 '';
}
}


摘自 lpdx111的专栏

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/478172.htmlTechArticlepublic static function saveExcel($objPHPExcel, $excelName, $output) { $objWriter = PHPExcel_IOFactory::createWriter ( $objPHPExcel, Excel5 ); if (! strpos ( $_SERVER [HTTP_USER_AGE...