PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY (Portuguese/Brazil)

Topics: Developer Forum, User Forum
Jan 18, 2012 at 2:49 PM

Hello

i'm using this code PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY for print date, the same is print this: 10/01/12, so i need

print this like 10/01/2012, but i don't make this, search in class code and not look some equals.

help me please.

Jan 18, 2012 at 2:58 PM

Try...

$format_date = array(
	'numberformat' => array(
		'code' => 'DD/MM/YYYY',
	),
);

$objPHPExcel->getActiveSheet()->getStyle($cell)->applyFromArray($format_date);

Jan 18, 2012 at 3:21 PM

great Scott,

perfect run

tank you so much