php - PHPExcel, Save string without changes -

i using phpexcel save multidimensional array data in xls file

this code:

    $arr = array(         array("01", "02", "03"),         array("04", "05", "06"),     );       // include phpexcel library      $objphpexcel = new phpexcel();     $objphpexcel->getactivesheet()->fromarray($arr);      $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel5');     $objwriter->save("file.xls"); 

my problem starting nulls removed in xls file. example saved not 01, 1.

how solve problem?

if want string numeric value retain leading zeroes, have 2 choices: write string using $objphpexcel->getactivesheet()->getcell('a1') ->setvalueexplicit( '01', phpexcel_cell_datatype::type_string ); (phpexcel_cell_datatype::type_string default, don't have specify argument)

or allow written number, , set format mask display leading zeroes

$objphpexcel->getactivesheet()->getstyle('a1')     ->getnumberformat()     ->setformatcode("00"); 

edit

you can apply style range of cells, not individual cells

$arr = array(     array("01", "02", "03"),     array("04", "05", "06"), );  // include phpexcel library $objphpexcel = new phpexcel(); $objphpexcel->getactivesheet()->fromarray($arr);  $objphpexcel->getactivesheet()->getstyle('a1:c2')     ->getnumberformat()     ->setformatcode("00");