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