$objPHPExcel->getActiveSheet()->getstyle("C".$num.":C".$num1)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);