thinkphp phpExcel 记录导出

使用phpexcel 导出记录
把下载好的phpexcel vendor 文件夹中即可
代码可以直接用 改成自己需要的数据

//导出
        public function xfdaochu(){
            $xlsName  = "User";
            $where['from']=array('in','1,2,6');
            $where=I('post.');
            if($where['uid']){
                $this->assign('c_uid',$where['uid']);
            }else{
                unset($where['uid']);
            }
            if($where['ygid']){
                $this->assign('c_ygid',$where['ygid']);
            }else{
                unset($where['ygid']);
            }
            if(!empty($where['stime'])&&!empty($where['etime'])){
                $where['pay_time']=array('BETWEEN',array(strtotime(date($where['stime'])),strtotime(date($where['etime']))));
                $this->assign('stime',$where['stime']);
                $this->assign('etime',$where['etime']);
            }else{
                if($where['stime']){
                    $where['pay_time']=array('egt',strtotime(date($where['stime'])));
                    $this->assign('stime',$where['stime']);
                }
                if($where['time']){
                    $where['pay_time']=array('elt',strtotime(date($where['etime'])));
                    $this->assign('etime',$where['etime']);
                }
            }
            $where['cid']=$this->cid;
            //生成表格数据

            $xlsCell  = array(
                array('uid','会员ID'),
                array('price','支付金额'),
                array('jifen','积分'),
                array('quanname','券名称'),
                array('from','消费来源'),
                array('pay_type','支付方式'),
                array('ygame','操作员工'),
                array('intro','说明'),
                array('pay_time','支付时间'),
            );
             $ls=M('pay_record')->where($where)->order('pay_time desc')->select();
            foreach($ls as $k=>$v){
                $yg=M('com_yuangong')->where(array('id'=>$v['ygid']))->find();
                $ls[$k]['ygname']=$yg['name'];
                $quan=M('quan_list')->where(array('id'=>$v['usqid']))->find();
                $ls[$k]['quanname']=$quan['name'];
                  $ls[$k]['uid']=$v['uid'];
                  $ls[$k]['price']=$v['price'];
                  $ls[$k]['jifen']=$v['jifen'];
                  $ls[$k]['quanname']=$v['quanname'];
                  switch($v['from']){
                    case '1':$ls[$k]['from']='自助扫码';break;
                    case '2':$ls[$k]['from']='收银员后台';break;
                    case '3':$ls[$k]['from']='员工扫码';break;
                  }
                  // $ls[$k]['e']=$v['from'];
                  switch($v['pay_type']){
                    case '1':$ls[$k]['pay_type']='微信支付';break;
                    case '2':$ls[$k]['pay_type']='会员卡支付';break;
                    case '3':$ls[$k]['pay_type']='支付宝支付';break;
                    case '4':$ls[$k]['pay_type']='现金支付';break;
                  }
                  // $ls[$k]['f']=$v['pay_type'];
                  $ls[$k]['ygame']=$v['ygname'];
                  $ls[$k]['intro']=$v['intro'];
                  $ls[$k]['pay_time']=date("Y-m-d H:i:s",$v['pay_time']);
            }
            $this->exportExcel($xlsName,$xlsCell,$ls);
            }




        public function exportExcel($expTitle,$expCellName,$expTableData){
            $xlsTitle = iconv('utf-8', 'gb2312', $expTitle);//文件名称
            $fileName =date('_YmdHis');//or $xlsTitle 文件名称可根据自己情况设定
            $cellNum = count($expCellName);
            $dataNum = count($expTableData);
            vendor("PHPExcel.PHPExcel");
            $objPHPExcel = new \PHPExcel();
            $cellName = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ');
            $objPHPExcel->getActiveSheet(0)->mergeCells('A1:'.$cellName[$cellNum-1].'1');//合并单元格
            // $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $expTitle.'  Export time:'.date('Y-m-d H:i:s'));
            for($i=0;$i<$cellNum;$i++){
                $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].'2', $expCellName[$i][1]);
            }
            // Miscellaneous glyphs, UTF-8
            for($i=0;$i<$dataNum;$i++){
                for($j=0;$j<$cellNum;$j++){
                    $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j].($i+3), $expTableData[$i][$expCellName[$j][0]]);
                }
            }
            ob_clean();
            header('pragma:public');
            header('Content-type:application/vnd.ms-excel;charset=utf-8;name="'.$xlsTitle.'.xls"');
            header("Content-Disposition:attachment;filename=$fileName.xls");//attachment新窗口打印inline本窗口打印
            $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
            $objWriter->save('php://output');
            exit;
    }