1
Vote

Leading 0 issue

description

Hi,

I am trying to add 0 in the sheet but its not getting add.


$objPHPExcel->getActiveSheet()->setCellValueExplicit('A1', '0029', PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->getActiveSheet()->getStyle('A3')->getNumberFormat()->setFormatCode('0000');

I have tried this both above code but its not working for me.

So can you please help me out with this?

Thanks,
Manish Soni

comments