phpexcel使用

设置居中

$objPHPExcel->getActiveSheet()->getStyle($cellRealName)->applyFromArray(
      array(
           'alignment' => array(
                'horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER
            )
     )
);

 设置单元内换行

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A4', “Hello\nWorld”)；

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

 设置默认行高

$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(30);

设置单元格宽度自适应

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

设置文字类型

$objPHPExcel->getActiveSheet()->setCellValueExplicit(
      $cellRealName,
      $_value,
       \PHPExcel_Cell_DataType::TYPE_STRING2
);    

冻结窗格

$objPHPExcel->getActiveSheet()->freezePane('A2');