How can I use PHP to generate real Excel files? PS: Do not use Phpexcel card

Source: Internet
Author: User
How do I use PHP to generate a real Excel file? PS: Do not use phpexcel too card!
Recently, there are projects that need to export data in large batches to Excel files, the early use of phpexcel, when the amount of data is less than the line! But in large quantities of data such as the 10,000 line, the memory consumed is too high, it is easy to overflow!

Using the Generate XML as an XLS format can be very efficient, but it will pop up when you open the file with the message "You're trying to open the XX." XLS ' format is inconsistent with the format specified by the file extension ... " It's very annoying! Want to ask how can you remove this hint? How to make a simple implementation of the real Excel file, but also can set a simple cell format!

Trouble knowing under the guidance! Thank you! ~ There are thick points of dedication! ~

------Solution--------------------
Explore
Using the Generate XML as an XLS format can be very efficient, but it will pop up when you open the file with the message "You're trying to open the XX." XLS ' format is inconsistent with the format specified by the file extension ... "

------Solution--------------------
CSV format can be opened directly with Excel, without any hint, do not know whether it meets your requirements?
  • 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.