phpexcel 格式设置

//格式设置
        $phpexcel->getActiveSheet()->mergeCells('A1:E1');//合并单元格（如果要拆分单元格是需要先合并再拆分的，否则程序会报错
        $phpexcel->getActiveSheet()->getRowDimension('1')->setRowHeight(24); //列高
        $phpexcel->getActiveSheet()->getColumnDimension('A')->setWidth(14);//设置列宽度
        $phpexcel->getActiveSheet()->getDefaultColumnDimension()->setWidth(28); //列宽
        $phpexcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(12); //字体大小
        $phpexcel->getDefaultStyle()->getFont()->setName('宋体');//字体
        $phpexcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $phpexcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//垂直居中
        $phpexcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//垂直居中
        $phpexcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);//全局居左
        $phpexcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true); //加粗
        $phpexcel->getActiveSheet()->getStyle('A2:E2')->getFont()->setBold(true); //加粗

$phpexcel->setActiveSheetIndex(0)->setCellValue('A1', $header);//设置表头数据