Ask to avoid the problem that the xls file phone number exported by phpexcel and the ID card are displayed in scientific notation! & Nbsp; phpexcel is used for export in recent projects. it is good to use, but there are several headaches, that is, when the exported data column contains & nbsp; 013434342333, 053482371284, 4222131231231231231 ask to avoid the problem that the xls file phone number exported by phpexcel and the ID card are displayed in scientific notation!
Phpexcel is used for export in recent projects, which is relatively good, but there are several headaches, that is, when exporting data columns, data of the type 013434342333, 053482371284, and 42221312312312312312213 is automatically displayed in scientific notation. for details, see how to display the complete numerical records. the version I used is 1.7.6. thank you, please let me know! Share:
------ Solution --------------------
$ ObjStyleA5
-> GetNumberFormat ()
-> SetFormatCode (PHPExcel_Style_NumberFormat: FORMAT_NUMBER );