// 引入PHPEXCEL文件
require_once('PHPExcel/PHPExcel.php');
require_once('PHPExcel/IOFactory.php');
$objPHPExcel = new \PHPExcel();
$iofactory = new \PHPExcel_IOFactory();
// 水平居中
$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// 垂直居中
$objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
// 设置excel列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
// 合并单元格
$objPHPExcel->getActiveSheet()->mergeCells('A1:C1');
$title = '标题';
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $title);
// 列名
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A2', '编号');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B2', '姓名');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C2', '年龄');
// 数据
$i = 3;
foreach($data as $v){
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $v['id']);
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, $v['name']);
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . $i, $v['age']);
    $i++;
}
// 设置边框
$objPHPExcel->getActiveSheet()->getStyle('A1:C' . ($i - 1))->applyFromArray(array(
    'borders' => array(
        'allborders' => array(
            'style' => \PHPExcel_Style_Border::BORDER_THIN
        ),
    ),
));
// 自动换行
$objPHPExcel->getActiveSheet()->getStyle('A1:C' . ($i - 1))->getAlignment()->setWrapText(TRUE);
// 下载
ob_clean();
$objPHPExcel->getActiveSheet()->setTitle('SetExcelName');
$objPHPExcel-> setActiveSheetIndex(0);
$objWriter = $iofactory->createWriter($objPHPExcel, 'Excel2007');
$filename = $title . date('YmdHi') . '.xlsx';
// 浏览器下载
header('Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Type:application/octet-stream');
header('Content-Disposition:attachment;filename="' . $filename . '"');
header('Cache-Control:max-age=0');
$objWriter->save('php://output');