The format of fields in the php excel reading content has changed. excel is a regular field: & nbsp; 201407170002 & nbsp; 201407170001 & nbsp; 201407160039 & nbsp; 201407160038 after being readable by PHP, it becomes: MA & nbsp; 02148MA & nbsp; 02148MA & nbsp; 02148MA & nbsp; the format of fields in the php excel file has changed.
Excel is a regular field:
201407170002
201407170001
201407160039
201407160038
201407160037
After being readable by PHP, it becomes:
MA 02148
MA 02148
MA 02148
MA 02148
MA 02148
How can this problem be solved? Use PHPExcel to read data.
------ Solution --------------------
IMPOSSIBLE. there is no similarity between the two.
You may have mistaken columns.
You can place the xls files for testing on the cloud disk.
------ Solution --------------------
View the data type of the original excel table
------ Solution --------------------
This?
Which column do you mean?
