mysql - Set format to text when export by php -

$objphpexcel->setactivesheetindex(0)             ->setcellvalue('a1', 'cardnumber')   $objphpexcel->getactivesheet()->setcellvalue('a' . $i, $objresult["cardnumber"]); 

as per phpexcel documentation, set format text, you'd use:

$objphpexcel->getactivesheet()     ->getstyle('a1')     ->getnumberformat()     ->setformatcode(phpexcel_style_numberformat::format_text); 

edit

however, transpires want isn't set style format text, store long numeric value string

for purpose, phpexcel has setcellvalueexplicit() method:

$objphpexcel->getactivesheet()     ->setcellvalueexplicit('a' . $i, $objresult["cardnumber"]); 

which defaults setting value datatype string rather identifying numeric , setting datatype number