Getting Difficulties in writing Excel 5 files

Topics: Developer Forum, Project Management Forum, User Forum
Aug 13, 2012 at 1:11 PM
Edited Aug 13, 2012 at 1:16 PM

Dear All,

I am using PHPExcel for writing generating xls file. I do have about 3000 of rows with 20 columns.

I have about 12 different colours to put on. But after completing about 1800 rows my code stops with no error message.

We are using database to get the color informtion and data

Is there any way to put the color information with the data?

I am using this piece of code to put the colour on. If I do comment the given code then my system works without any problem.

I have collected all the color information in an array and set as above mentioned in each cell.

foreach($color[$row] as $color_key => $color_value) {
                        $worksheet->getStyleByColumnAndRow($column,$row)
                            ->getFill()
                            ->getStartColor()
                            ->setRGB(str_replace("#", "", $color_value));
                        $column++;
                    }

Please suggest me the best way to use the color information.

Thanks in advance.

Coordinator
Aug 15, 2012 at 11:34 AM

Is anything written to log? timeout?

Aug 16, 2012 at 5:18 AM

No I am not getting any error related to this.