$userBrowser = $_SERVER['HTTP_USER_AGENT']; //判断是否是ie内核 $fileName = '会员列表-'.date('Y-m-d', time()).'.xls'; if( preg_match( '/MSIE/i', $userBrowser ) ) { $fileName = urlencode($fileName); }else{ $fileName = iconv('UTF-8', 'GBK//IGNORE', $fileName); } header('pragma:public'); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename='.$fileName.''); //日期为文件名后缀 header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); //excel5为xls格式,excel2007为xlsx格式 $objWriter->save('php://output');
如对本文有疑问, 点击进行留言回复!!
20.7.17 笔记算数运算符 复合运算符重载 比较运算重载 多态 设计原则 类的单一职责 依赖倒置 组合复用原则 里氏替换 迪米特法则 矩阵转置原理
网友评论