I’m trying to change the datatype for a whole column (for eg: i need to change for “M” Column to general format). Its displaying as 2.00
in quantity field,I need to change this whole column to general format ie. display as "2"
. But its not changing the datatype.
Here is the code:
$objPHPExcel->getActiveSheet() ->setCellValue( $aCells[$eExcelColumn] . $eExcelRow, $sCellData , PHPExcel_Cell_DataType::TYPE_NUMERIC ); $objPHPExcel->getActiveSheet()->getStyle('M1:M97') ->getNumberFormat() ->setFormatCode('0');
How to do for the whole column “M” as general format
Advertisement
Answer
PHPExcel doesn’t support column or row styling: you need to set the style for a range
of cells, exactly as you are doing with
$objPHPExcel->getActiveSheet()->getStyle('M1:M97') ->getNumberFormat() ->setFormatCode('0');
if you want General
format rather than '0'
, then set it to General
Instead:
$objPHPExcel->getActiveSheet()->getStyle('M1:M97') ->getNumberFormat() ->setFormatCode('General');
or
$objPHPExcel->getActiveSheet()->getStyle('M1:M97') ->getNumberFormat() ->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_GENERAL);