merge cells and apply style phpexel

Asked Aug 11 '15 at 07:04

Active Aug 11 '15 at 07:15

Viewed 288 times

When doing merge cells and applying style in loop script is giving fatal error mentioned below.

Fatal error: Maximum execution time of 30 seconds exceeded in D:\xampp\htdocs\bookings\vendor\phpoffice\phpexcel\Classes\PHPExcel\Cell.php on line 892

NOTE: but if we use it out side the loop it works fine, My code which i use to apply style and merge the cell is as below.

$range = chr($alpha).'1:'.chr($alpha+1).'1';
$spreadsheetWriter->mergeCell($range);
$spreadsheetWriter->setCellStyle($range);

What is wrong here, or is there any way which i can use to handle fatal error.

Thanks Amit

edited Aug 11 '15 at 07:15

Muhammad Hassaan

7,296
6
30
50

asked Aug 11 '15 at 07:04

Amit Shah

1,380
1
10
19

Always try to apply styles outside of a loop where possible..... and for a merge range, just apply the style to the top-left cell of the merge range – Mark Baker Aug 11 '15 at 07:17
Incidentally, why aren't you actually specifying any style to set? – Mark Baker Aug 11 '15 at 07:31
@MarkBaker actually setCellStyle is a function of my class, which sets font weight to bold, and cell alignment to center. – Amit Shah Aug 11 '15 at 08:32
Then it might be useful to see some of the logic of your wrapper class – Mark Baker Aug 11 '15 at 21:11

merge cells and apply style phpexel

0 Answers0