PHPExcel for loop timeout

Question

I have this code where I want to set from 3 to 333 to have a certain row height at every 30 interval, meaning at row 3, 33, 63, 93 up till 333:

for ($i=3; $i<340; $i+30){
        $objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(57);
}

But when I click on controller actionGenerate(), it doesn't generate and timeouts me after 30 seconds. Can I know why isn't it generating?

If I were to use the manual way, as in doing line by line, PLUS having so many different kinds of settings, I'd be exhausted.

Jelle de Fries · Accepted Answer · 2015-05-06T08:13:16.040

3

PHP limits the execution time of any script. The default time is 30 seconds. Your script probably takes longer than 30 seconds to execute.

Set your set_time_limit to 0. This will set it to unlimited.

like this:

set_time_limit(0);
for ($i=3; $i<340; $i+=30){ // <--- here was your problem
        $objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(57);
}

And try again.

Info about set_time_limit in the docs

-- edit--

The problem was in the for loop.

$i + 30 adds 30 to $i but it does not assign it. It should be $i +=30

edited May 06 '15 at 08:13

answered May 06 '15 at 07:24

Jelle de Fries

885
1
11
20

It doesn't timeout, but it takes forever to load. Is there something wrong somewhere in the code? – NewbieCoder May 06 '15 at 07:42
1

Yes, it should be `$i+=30` it now adds `30` to `i` but it doesn't assign it. – Jelle de Fries May 06 '15 at 08:12
@Yeen np, glad I could help. – Jelle de Fries May 06 '15 at 08:30

PHPExcel for loop timeout

1 Answers1