Why are some data imported into phpexcel incorrect?

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.