Upload the xls Document. The value of a column in the document is too long. The Read result is a scientific notation. for details, see content.

Upload the xls Document. The value of one of the columns is too long. The Read result is a scientific notation. for details, see content 1. & nbsp; Upload xls2. & nbsp; one of the columns is & nbsp; waybill number, which has 22 bits. the format is as follows & nbsp; order number & nbsp; & nbsp; waybill number & n Upload The xls document. The value of one column is too long. The Read result is a scientific notation. for details, see content.
1. Upload xls
2. one of the columns is the waybill number with a value of 22 characters. the format is as follows:
Order No. waybill No. Logistics
1 1234567890987654321234 usps
2 1234567890987654323224 usps
......
PHP processing code:
$ Xls_obj = new Helper_Excel ();
$ Xls_obj-> readFile ($ filename );
$ Sheet = $ xls_obj-> toHeaderMap ();
Foreach ($ sheet as $ key => $ row ){......}
The waybill number has become a scientific notation.
This column of the Excel document has been changed to the text format.

Thank you for your thoughts.
Share:
------ Solution --------------------
Treat it as a string, and the int type is out of bounds.