Phpexcel Import data part of the data is wrong?

Source: Internet
Author: User

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.

  • 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.