Phpexcel Times Out


I am using PHPExcel for exporting data from oracle db… i have these

options of date range to choose from for selecting which datas to export.

the problem is, when I export let’s say 1 month of data, the script dies.

what I did in order to try to fix the issue was

  • change max_execution_time = 1800 ( this is 30 minutes right? )

  • use set_time_limit()

but no success. the script still dies when data is like too many…

but when I only choose like 2 weeks, 1 week, or a few days amount of data, the exporting works

fine without any hassle,

anyone who encountered this issue?


After of how many seconds occurs the timeout?

Also check with unlimited time


I can’t actually tell, because it doesn’t finish writing the Excel file at all if the data is too big

the max_execution_time = 60

and then, before the $this->phpexcel(), i set the


but none of them has helped to let the script finish writing the spreadsheet

I had a similar problem with PHPExcel, but I can’t remember what I did to solve it. It might have been a memory issue though, so try increasing your memory_limit ini value.

nah…it didn’t helped even i increased the max_execution_time = 1800

What did you set the memory limit to?

max_execution_time = 1800


No, memory_limit. I’m saying it may be a memory issue rather than a timeout issue.

Mine is currently set to:

memory_limit = 128M

Try that for testing at least.

aren’t there any dangers on that? , it’s a huge site it might crawl if I’ll run the script with that adjusted memory

I’m suggesting you set it that high for testing to determine whether memory is the problem or not. If it is, you can tweak the value later.

the memory_limit = 512M

isn’t that huge already?