There does not seem to be a way for me to get around the memory limit problem.
I have set memory for PHP to 1024MB but still I run out. I am writing 20,000 rows to as many as 6 sheets inside one workbook. I'm not doing anything very complex. just writing strings to each column. no formulas and no formatting.
I'm hoping there are some creative ways to use phpexcel to get around the memory problem.
What about writing one sheet at a time, closing that sheet in some way and writing to the next one? I don't need for the entire thing to be in memory since once I'm done with the one sheet I won't be making any changes to it. I just need to save
it at that point and then create the next sheet inside the workbook.
There seems to be a lot of mention of the memory limit problem but not a lot of creative ways to get around it. Yes I am using cell caching. I have tried all the different options. But in the end the memory problem renders this entire package
useless for my needs. A shame since I am only writing text into these spread sheets. I can generate a csv version in a fraction of the time which will open in Excel also. In fact the only reason I'm using phpexcel is so that I can get the
several worksheets in one file - can't do this with csv files…
Can anyone point me in the right direction?