PHPExcel - 从代码编辑时格式化丢失

// 引入 PHPExcel 函数库
require_once 'PHPExcel/PHPExcel.php';

// 初始化 PHPExcel 对象
$objPHPExcel = new PHPExcel();

// 设置表格标题
$objPHPExcel->setTitle('Test Sheet');

// 设置单元格颜色
$objPHPExcel->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID );
$objPHPExcel->getActiveSheet()->getStyle('A1:E1')->getFont()->setName('Arial')->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1:E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE );

// 设置行高列宽
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);

// 设置字体样式
$objPHPExcel->getActiveSheet()->getStyle('A1:E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1:E1')->getFont()->setSize(12);

// 设置行高
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30);

// 添加数据
$objPHPExcel->getActiveSheet()->setCellValue('A1', '姓名');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '年龄');
$objPHPExcel->getActiveSheet()->setCellValue('C1', '性别');
$objPHPExcel->getActiveSheet()->setCellValue('D1', '邮箱');
$objPHPExcel->getActiveSheet()->setCellValue('E1', '电话');

// 保存为 Excel 文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$filename = 'example.xlsx'; // Excel 文件名
$objWriter->save(dirname(__FILE__) . '/'.$filename);