Why not all of them are wrong? I only found some errors: excel is like this. after a database is inserted, there are more than one thousand data records. no matter how it is imported, there are always a few errors, what is the cause? It's really strange. Is there a reminder? Thank you ~
Why are not all errors? only some errors are found:
Excel is like this.
This is the case after the database is inserted.
There are a total of more than one thousand data records. no matter how the data is imported, there are always a few errors. what is the cause? It's really strange.
Is there a reminder? Thank you ~
Reply content:
Why are not all errors? only some errors are found:
Excel is like this.
This is the case after the database is inserted.
There are a total of more than one thousand data records. no matter how the data is imported, there are always a few errors. what is the cause? It's really strange.
Is there a reminder? Thank you ~
It has been solved. phpexcel uses "," to splice the read data.
It will be normal to change to another concatenated character and there will be no conflict
Thank you for your invitation. I guess there are invisible special characters or special formats in your excel file. We recommend that you filter special characters, such as line breaks and space characters, into the data you want to store in the database. For reference only
How to identify separators ~ CSV uses a comma as the identifier. We recommend that you check the source code to see how phpexcel is implemented.