导出excel参考

var itemExport = function () {
        var objs = document.getElementById("_query_form").elements;
        var i = 0;
        var cnt = objs.length;
        var obj;
        var url = '';
        var order = '';
        var page = document.getElementsByClassName("page selected")[0];


        for (i = 0; i < cnt; i++) {
            obj = objs.item(i);
            url += '&' + obj.name + '=' + obj.value;
        }
        if( typeof page == "undefined" ) {
            page = 1;
        }else{
            page = page.innerText;
        }
        var act = document.getElementById("export");
        act.href = "index.php?r=forms/forms/export&formname=<?php echo $formname; ?>"+"&page="+(page-1)+url+"&q_order="+order;
    }
public function actionExport($formname){


        $page = $_GET['page'] == '' ? 0 : $_GET['page']; //当前页码
        $_GET['page']=$_GET['page']+1;
        $args = $_GET['q']; //查询条件


        if($args['name']=='姓名')
            $args['name'] = '';
        if($args['phone']=='手机号')
            $args['phone'] = '';


        if($args['appid']==''&&Yii::app()->user->getState("type")==Operator::TYPE_BANK){
            $args['appid'] = Yii::app()->user->getState("appid");
        }
        $this->pageSize = 9999999999999;
        $rows = FormValue::getAllInfo($formname,$page,$this->pageSize,$args);
        unset($rows['total_num']);
        unset($rows['page_num']);
        //处理图片路径
        foreach($rows as $k=>$v){
            $rows[$k]['img'] = str_replace('..','http://wx.aiopos.cn',$v['img']);
        }
        //为指定表单制定表格
        if($formname == 'forecast'){


            $objectPHPExcel = new PHPExcel();
            $objectPHPExcel->setActiveSheetIndex(0);


            //报表头的输出
            $objectPHPExcel->getActiveSheet()->mergeCells('B1:G1');
            $objectPHPExcel->getActiveSheet()->setCellValue('B1','股市预测抽奖—信息表');
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('B2','股市预测抽奖—信息表');
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('B2','股市预测抽奖—信息表');
            $objectPHPExcel->setActiveSheetIndex(0)->getStyle('B1')->getFont()->setSize(24);
            $objectPHPExcel->setActiveSheetIndex(0)->getStyle('B1')
                ->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('B2','日期：'.date("Y年m月j日"));


            //表格头的输出
            $objectPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(5);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('B3','编号');
            $objectPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(6.5);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('C3','姓名');
            $objectPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(17);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('D3','身份证号');
            $objectPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(22);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('E3','手机号');
            $objectPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('F3','预测点位数值');
            $objectPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue('G3','上传图片');
            $objectPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(50);


            //设置居中
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3')
                ->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);


            //设置边框
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3' )
                ->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3' )
                ->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3' )
                ->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3' )
                ->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3' )
                ->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);


            //设置颜色
            $objectPHPExcel->getActiveSheet()->getStyle('B3:G3')->getFill()
                ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FF66CCCC');


            //明细的输出
            foreach($rows as $k=>$v){
                static $i = 1;
                $objectPHPExcel->getActiveSheet()->setCellValue('B'.($i+3),$i);
                $objectPHPExcel->getActiveSheet()->setCellValue('C'.($i+3),$v['name']);
                $objectPHPExcel->getActiveSheet()->setCellValue('D'.($i+3),"'".$v['sn_num']);
                $objectPHPExcel->getActiveSheet()->setCellValue('E'.($i+3),"'".$v['phone']);
                $objectPHPExcel->getActiveSheet()->setCellValue('F'.($i+3),$v['forecast']);
                $objectPHPExcel->getActiveSheet()->setCellValue('G'.($i+3),$v['img']);


                //设置边框
                $currentRowNum = $i+4;
                $objectPHPExcel->getActiveSheet()->getStyle('B'.($i+4).':G'.$currentRowNum )
                    ->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
                $i++;
            }
            ob_end_clean();
            ob_start();


            header('Content-Type : application/vnd.ms-excel');
            header('Content-Disposition:attachment;filename="'.'股市预测—信息表-'.date("Y年m月j日").'.xls"');
            $objWriter= PHPExcel_IOFactory::createWriter($objectPHPExcel,'Excel5');
            $objWriter->save('php://output');