PHPExcel returns the same number as the timestamp !!! The data obtained by php is a string of numbers 2009061503335 (timestamp ). After being output in PHPExcel, it becomes 2.00906E + 12. I want it to display the timestamp normally, because the order number is based on the timestamp. $ PHPExcel-& gt; getActiveSheet ()-& gt; getStyle (A1)-& gt; g PHPExcel: this is what happens when you output a number like a timestamp !!!
The data obtained by php is a string of numbers 2009061503335 (timestamp ).
After being output in PHPExcel, it becomes 2.00906E + 12.
I want it to display the timestamp normally, because the order number is based on the timestamp.
$ PHPExcel-> getActiveSheet ()-> getStyle ('A1')-> getNumberFormat ()-> setFormatCode (PHPExcel_Style_NumberFormat: FORMAT_TEXT );
This is the same. why?
Share: More
------ Solution --------------------
View the excel file and adjust the cell format. for export, the field can be exported as a string. During export, a space is added before the value.