如何使用PHPExcel将0001放入excel报告中

Question

I'm having some problems with my code in PHPexcel on generating report. I've got numbers like 0001,0002,0087 in a textbox and when I transfer it to Excel, to make a report the output is 1,2,87. Why is that?

my var to pass value to generate excel report using PHPExcel

$aic = isset($_POST['aic'.$n]) ? $_POST['aic'.$n] : "";

Answer 1

I think setting your cell format to 4 digits number should do the trick. Try this:

$objPHPExcel->getActiveSheet()->getStyle('A1')->getNumberFormat()->setFormatCode('0000');