How can I use Php to generate a real Excel file? PS: Do not use PHPEXCEL too card
Source: Internet
Author: User
How can I use Php to generate a real Excel file? PS: it is too difficult to use PHPEXCEL! Recently, a project needs to export data in large batches to an Excel file. PhpExcel is used in the early stage. it is okay when the data volume is small! However, when a large volume of data reaches 10 thousand rows, the memory consumed is too high and can easily overflow! If you use the generated XML to save it as XLS format, you can quickly ask how to use Php to generate a real Excel file? PS: it is too difficult to use PHPEXCEL!
Recently, a project needs to export data in large batches to an Excel file. PhpExcel is used in the early stage. it is okay when the data volume is small! However, when a large volume of data reaches 10 thousand rows, the memory consumed is too high and can easily overflow!
Saving the generated XML file to the XLS format is very efficient, but the prompt "you are trying to open 'XX. the XLS format is inconsistent with the format specified by the file extension... "very annoying! How can I remove this prompt? How can we generate a real excel file and set a simple cell format!
Thank you for your understanding! Thank you !~ Great dedication !~
------ Solution --------------------
Discussion
Saving the generated XML file to the XLS format is very efficient, but the prompt "you are trying to open 'XX. the XLS format is inconsistent with the format specified by the file extension..."
------ Solution --------------------
The csv format can be opened directly in excel without any prompts. do you know if 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.