php本地excel文件,PHPExcel php execl下载或保存到本地

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的专栏

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值