记录PHPExcel 常用的设置属性

单元格换行

$objPHPExcel ->setActiveSheet() ->setCellValue( 'A4' , “Hello\nWorld”);

$objPHPExcel ->getActiveSheet()->getStyle( 'A4' )->getAlignment()->setWrapText(true);

单元格居中

$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

所有单元格居中

$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

单元格画边框

1. $styleArray = array(  
2.         'borders' => array(  
3.             'allborders' => array(  
4.                 //'style' => PHPExcel_Style_Border::BORDER_THICK,//边框是粗的  
5.                 'style' => PHPExcel_Style_Border::BORDER_THIN,//细边框  
6.                 //'color' => array('argb' => 'FFFF0000'),  
7.             ),  
8.         ),  
9.     );  
10.    $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray($styleArray);