thinkphp框架中使用PHPExcel，按模板导出excel

public function exportAll()
    {
        //获取年月和考勤天数
        $date = $this->_GET('date');
        $days = $this->_GET('days');

        require_once("Classes/PHPExcel.php");
        include("Classes/PHPExcel/IOFactory.php");
        $temPath = "./TempFile/kaoqing.xlsx";
        //检查文件路径
        if(!file_exists($temPath)){
            $this->error('模板不存在');
            return;
        }
        //加载模板
        $phpexcel =  PHPExcel_IOFactory::createReader("Excel2007")->load($temPath);
        
        $card_create_db =M('Qyattendance_record');
        $groupMember = $card_create_db->alias("r")->join('tp_Qyusers as u on u.id =r.uid','left')
        ->where("date_format(r.date,'%Y/%m') ='".$date."'")
        ->group('uid')
        ->field('uid,r.name,u.name as fullname, count(r.date) as realdays')
        ->select();
        $rowIndex = 5;
        $i = 0;
        foreach($groupMember as $item){
            //一览表写入数据
            //检查名称
            if(empty($item['fullname'])){
                $item['fullname'] = "空名称".$i;
            }
            $phpexcel->getSheet(0)->setCellValue('B'.$rowIndex, $item['name']);
            $phpexcel->getSheet(0)->setCellValue('C'.$rowIndex, $item['fullname']);
            $phpexcel->getSheet(0)->setCellValue('D'.$rowIndex, $days);
            $phpexcel->getSheet(0)->setCellValue('E'.$rowIndex, $item['realdays']);
            if($i > 0){
                //拷贝表
                $cloned_sheet = clone $phpexcel->getSheet(1);
                $cloned_sheet->setTitle($item['fullname']);
                $phpexcel->addSheet($cloned_sheet);
            }else{
                $phpexcel->getSheet(1)->setTitle($item['fullname']);
            }
            //获取员工考勤数据
            $members = $card_create_db->alias("r")->join('tp_Qyusers as u on u.id =r.uid','left')
                        ->where("date_format(r.date,'%Y/%m') ='".$date."' and r.uid = '".$item['uid']."'")
                           ->order('uid')
                           ->field('r.uid,r.name as rname,r.creatime,r.outtime,r.worktime,r.date,u.name as fullname,`outtime`-`creatime`-3600 as seconds')
                           ->select();
            $memberIndex = $i + 1;
            //写入员工详细考勤数据
            $vindex = 2;
            $j = 1;
            foreach($members as $v){
                //编号
                $phpexcel->getSheet($memberIndex)->setCellValue('A'.$vindex,$j);
                //姓名
                $phpexcel->getSheet($memberIndex)->setCellValue('B'.$vindex,$v['fullname']);
                //日期
                $phpexcel->getSheet($memberIndex)->setCellValue('C'.$vindex,$v['date']);
                //检查时间
                if(empty($v['creatime'])){
                    $starttime = '';
                }else{
                    $starttime = date('H:i:s',$v['creatime']);
                }
                if(empty($v['outtime'])){
                    $endtime = '';
                }else{
                    $endtime = date('H:i:s',$v['outtime']);
                }
                //上班时间
                $phpexcel->getSheet($memberIndex)->setCellValue('D'.$vindex,$starttime);
                //下班时间
                $phpexcel->getSheet($memberIndex)->setCellValue('E'.$vindex,$endtime);
                //休息时间
                $phpexcel->getSheet($memberIndex)->setCellValue('F'.$vindex,'01:00');
                //计算考勤时间
                $time = '';
                $remark = '';
                $seconds = (int)$v['seconds'];
                if($seconds > 0){
                    $hours = floor($seconds/3600);
                    $minutes = floor($seconds%3600/60);
                    $time = $hours.":".$minutes;
                    if($seconds < 28800){
                        $remark = '考勤时间不足';
                    }
                }else{
                    $time = '00:00';
                }
                if(empty($v['outtime'])){
                    $remark = '未签下班';
                }
                $phpexcel->getSheet($memberIndex)->setCellValue('G'.$vindex,$time);
                //备注
                $phpexcel->getSheet($memberIndex)->setCellValue('H'.$vindex,$remark);
                $vindex++;
                $j++;
            }
            $i++;
            $rowIndex++;
        }
        
        //导出属性设置
        $date = str_replace("/","_",$date);
        $outputFileName = "kaoqing_".$date.".xlsx";
        require_once("Classes/PHPExcel/Writer/Excel2007.php"); 
        $objWriter = new PHPExcel_Writer_Excel2007($phpexcel);
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="'.$outputFileName.'"');
        header("Content-Transfer-Encoding: binary");
        header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
        header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Pragma: no-cache");
        $objWriter->save('php://output');
    }