bzzear
- bzzear 2018-01-06 已签到连续签到1天,获得了5个金钱
- bzzear 2018-01-03 已签到连续签到2天,获得了10个金钱
- bzzear 发表了说说红鲤鱼与绿鲤鱼与驴
- bzzear 2018-01-02 已签到连续签到1天,获得了5个金钱
- bzzear 2017-12-29 已签到连续签到1天,获得了5个金钱
- bzzear 2017-12-27 已签到连续签到1天,获得了5个金钱
给你个创建excel的方法, 肯定好用
public static function createExcel(PHPExcel $objPHPExcel = NULL,$fileName = 'example.xlsx',$download = false) { $objPHPExcel = $objPHPExcel ? $objPHPExcel : new PHPExcel; $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); if($download){ $fileName = basename($fileName); $fileName = iconv("utf-8", "gb2312", $fileName); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename='.$fileName); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); //文件通过浏览器下载 }else{ $dirname = dirname($fileName); if ($dirname != '.') { //文件路径如果不存在则递归创健 CommonFun::recursionMkDir($dirname); } $objWriter->save($fileName); //脚本方式运行,保存在指定目录 if(!file_exists($fileName)) { return false; } return true; } } self::createExcel($objPHPExcel,$fileName);
@329s CommonFun::recursionMkDir($dirname); 这个可以用Yii 自带的FileHelper::createDirectory($dirname)
给你个创建excel的方法, 肯定好用
public static function createExcel(PHPExcel $objPHPExcel = NULL,$fileName = 'example.xlsx',$download = false) { $objPHPExcel = $objPHPExcel ? $objPHPExcel : new PHPExcel; $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); if($download){ $fileName = basename($fileName); $fileName = iconv("utf-8", "gb2312", $fileName); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename='.$fileName); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); //文件通过浏览器下载 }else{ $dirname = dirname($fileName); if ($dirname != '.') { //文件路径如果不存在则递归创健 CommonFun::recursionMkDir($dirname); } $objWriter->save($fileName); //脚本方式运行,保存在指定目录 if(!file_exists($fileName)) { return false; } return true; } } self::createExcel($objPHPExcel,$fileName);
- bzzear 2017-12-25 已签到连续签到1天,获得了5个金钱