Why not all are wrong, only found some errors:
Excel is like this
This is what happens when you insert a database.
A total of more than 1000 data, no matter how to import, the error is always a few, in the end what causes it? It's really weird.
Does anyone remind you? Thank you for the first ~
Reply content:
Why not all are wrong, only found some errors:
Excel is like this
This is what happens when you insert a database.
A total of more than 1000 data, no matter how to import, the error is always a few, in the end what causes it? It's really weird.
Does anyone remind you? Thank you for the first ~
has been solved, phpexcel itself is using "," to splice the data read to the
It's normal to change to another stitching character, and there's no conflict.
Thank you for inviting me. I guess the data in your Excel file has an invisible special character or special format. I'll give you a suggestion. The processing of the corresponding data in the storage, such as line break characters and so on, is a special filter. For reference only
The problem with the identification of separators is that the comma is used as the identifier in the CSV. Suggest can look at the source code, see how Phpexcel is realized.