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! Saving the generated XML file to the XLS format is very efficient, but the prompt "you are trying to open 'XX. XLS 'Appears. 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!
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?
