For memory errors during PHPExcel usage, a report program needs to be developed recently and combined with excel. Therefore, a PHP Excel processing database named PHPExcel is selected.
However, PHPExcel is prone to memory errors during execution, and memory usage is very serious. I only imported a file of 2 MB, which occupied 40 MB of memory.
When I write the data into Excel again, it takes up more memory, close to MB.
So I searched the internet, and said to modify the file and add the code to release the memory. But the effect is not great.
Later I found the method for setting the cache, but it didn't work.
Later, I planned to write data into an Excel file in segments, but I didn't find a method to append the data. by default, the data is overwritten.
Who can handle high memory usage in PHPExcel? Or the method used to write data into the Excel file segment. In short, as long as you use less memory, it is not very high.
Reply to discussion (solution)
Okay... I encountered the same problem with you... Solution
Khan, I also met ..
I have the same problem.
The same request is ?????, Help me solve this problem.