php 导出excel

include_once ("mysql.db.php");
include_once ("./Classes/PHPExcel.php");
header("Content-Type:text/html;charset=utf-8"); 
    $db = new MySQLDB();
    $result = $db->query("SELECT * FROM `myall`.`test`");
    $objPHPExcel = new PHPExcel();
        //表头
		//背景填充颜色
		$objPHPExcel->getActiveSheet()->getStyle( 'A1:CH1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
		$objPHPExcel->getActiveSheet()->getStyle( 'A1:CH1')->getFill()->getStartColor()->setARGB('6fa8dc');
		//设置居中
		$objPHPExcel->getActiveSheet()->getStyle( 'A1:CH1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle( 'A1:CH1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//设置默认字体
		$objPHPExcel->getActiveSheet()->getStyle( 'A1:CH1')->getFont()->setName( '微软雅黑');
		$objPHPExcel->getActiveSheet()->getStyle( 'A1:CH1')->getFont()->setSize(12);
		$objPHPExcel->getDefaultStyle()->getFont()->setName( '微软雅黑');
		$objPHPExcel->getDefaultStyle()->getFont()->setSize(12);
		
        $title = array('Sender','Receiver', 'Source', 'TimeStamp', 'Id','CountryCode','SchemaVersion','RecordIdentifier','CampaignsourceCode','BackendCustomerId','BackendSystemName');
        $head = array('A','B','C','D','E','F','G','H','I','J','K');

        $titlea = $objPHPExcel->setActiveSheetIndex(0);
        for($i=0; $i<count($title);$i++){
            $titlea->setCellValue($head[$i].'1',$title[$i]);
        }
		
		$k =1;
         while($row = mysqli_fetch_array($result)){
			 $num = $k + 1;
			 $objPHPExcel->setActiveSheetIndex(0)
                 //Excel的第A列，uid是你查出数组的键值，下面以此类推
                 ->setCellValue('A' . $num, 'SILO')
                 ->setCellValue('B' . $num, 'CARMEN')
                 ->setCellValue('C' . $num, '')
                 ->setCellValue('D' . $num, date('Ymd',$row['dates']).'-000000')
                 ->setCellValue('E' . $num, $k)
                 ->setCellValue('F' . $num, 'CN')
				 ->setCellValue('G' . $num, '4.5.1')
				 ->setCellValue('H' . $num, '')
				 ->setCellValue('I' . $num, '1-32618583897')
				 ->setCellValue('J' . $num, '')
				 ->setCellValue('K' . $num, '');
				
				 
				 $k++;
		 }
		 //添加边框
		 $styleThinBlackBorderOutline = array(
        'borders' => array(
            'allborders' => array( //设置全部边框
                'style' => \PHPExcel_Style_Border::BORDER_THIN //粗的是thick
            ),

        ),
    );
    $objPHPExcel->getActiveSheet()->getStyle( 'A1:CH'.$k)->applyFromArray($styleThinBlackBorderOutline);
	    //设置列宽
		$objPHPExcel->getActiveSheet()->getDefaultColumnDimension()->setWidth(25);
		//设置高度
		//$objPHPExcel->getActiveSheet()->getDefaultColumnDimension()->setHeight(15);
	
		
        $objPHPExcel->getActiveSheet()->setTitle('618');
        $objPHPExcel->setActiveSheetIndex(0);
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		ob_end_clean();//清除缓存以免乱码出现
        $objWriter -> save('表名.xlsx');
		header('location:./mail/phpmailera.php');
        exit;

 

效果如下：