PHPexcel 导出excel表格

1、下载phpexcel文件

2、引入类文件

include_once "lib/PHPExcel/Classes/PHPExcel.php";
include_once "lib/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php";

3、

$objPHPExcel = new PHPExcel();
            $objPHPExcel->setActiveSheetIndex(0);
            $objPHPExcel->getActiveSheet()->setTitle('考试记录');//标题

			/*设置excel表格头*/
            $index = 1;
            $objPHPExcel->getActiveSheet()->setCellValueExplicit('A'.$index,'序号',PHPExcel_Cell_DataType::TYPE_STRING);
            $objPHPExcel->getActiveSheet()->setCellValueExplicit('B'.$index,'姓名',PHPExcel_Cell_DataType::TYPE_STRING);
            $objPHPExcel->getActiveSheet()->setCellValueExplicit('C'.$index,'校区',PHPExcel_Cell_DataType::TYPE_STRING);
            $objPHPExcel->getActiveSheet()->setCellValueExplicit('D'.$index,'得分',PHPExcel_Cell_DataType::TYPE_STRING);
            $objPHPExcel->getActiveSheet()->setCellValueExplicit('E'.$index,'考试时间',PHPExcel_Cell_DataType::TYPE_STRING);
            $objPHPExcel->getActiveSheet()->setCellValueExplicit('F'.$index,'用时',PHPExcel_Cell_DataType::TYPE_STRING);
			
			/*设置表格内容*/
            foreach($scores as $key => $p)
            {
                
                    if($p['ehtime'] >= 60){
                        if($p['ehtime']%60){
                            $p['ehtime'] = (intval($p['ehtime']/60)+1).'分钟';
                        }else{
                            $p['ehtime'] = intval(['ehtime']/60).'分钟';
                        }
                    }else{
                        $p['ehtime'] = $p['ehtime'].'秒';
                    }
                    $index = $key + 2;
                    $objPHPExcel->getActiveSheet()->setCellValueExplicit('A'.$index,$index - 1,PHPExcel_Cell_DataType::TYPE_STRING);
                    $objPHPExcel->getActiveSheet()->setCellValueExplicit('B'.$index,$p['usertruename'],PHPExcel_Cell_DataType::TYPE_STRING);
                    $objPHPExcel->getActiveSheet()->setCellValueExplicit('C'.$index,$p['name'],PHPExcel_Cell_DataType::TYPE_STRING);
                    $objPHPExcel->getActiveSheet()->setCellValueExplicit('D'.$index,$p['ehscore'],PHPExcel_Cell_DataType::TYPE_STRING);
                    $objPHPExcel->getActiveSheet()->setCellValueExplicit('E'.$index,date('Y-m-d H:i:s',$p['ehstarttime']),PHPExcel_Cell_DataType::TYPE_STRING);
                    $objPHPExcel->getActiveSheet()->setCellValueExplicit('F'.$index,$p['ehtime'],PHPExcel_Cell_DataType::TYPE_STRING);
            }
            
            $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
            
            $fname = '/data/out/'.TIME.'.xlsx';//文件名
            $fdir = $_SERVER['DOCUMENT_ROOT'].'/data/out/'.TIME.'.xlsx';//文件的保存地址
            
            $objWriter->save($fdir);