bzzear

bzzear

这家伙有点懒,还没写个性签名!

  • 财富值3110
  • 威望值80
  • 总积分4330

个人信息

  • 2018-01-06 已签到
    连续签到1天,获得了5个金钱
  • 2018-01-03 已签到
    连续签到2天,获得了10个金钱
  • 发表了说说
    红鲤鱼与绿鲤鱼与驴
  • 2018-01-02 已签到
    连续签到1天,获得了5个金钱
  • 2017-12-29 已签到
    连续签到1天,获得了5个金钱
  • 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);
    

    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);
    
  • 2017-12-25 已签到
    连续签到1天,获得了5个金钱
总监 等级规则
4330/5000
资料完整度
30/100
用户活跃度
0/100

Ta的关注

1

Ta的粉丝

8

Ta的访客

19