I am automating an excel spreadsheet using PHP.
I have been looking for a way to pragmatically format a cell to a percentage in PHPExcel.
I want to change a value like
assuming your cell is A1 ..
$objPHPExcel->getActiveSheet()->getStyle('A1') ->getNumberFormat()->applyFromArray( array( 'code' => PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00 ) );