Editting big files

Topics: Developer Forum, User Forum
Jan 15, 2008 at 3:05 AM
I saved my excel 2003 file as an excel 2007 xlsx. The file size was reduced from 674K to 350K. However, I still could not read it and obtain the following mistake.

21:37:54 Load from Excel2007 file
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to all
ocate 6648 bytes) in C:\Program Files\PHP\Classes\PHPExcel\Style\Color.php on li
ne 590

The color.php only has 255 lines.

I used $objPHPExcel = $objReader->load("test.xlsx") from the sample provided. Does it mean I can't edit a file bigger than 130K using this method? Are there any other ways? Can anybody kindly answer my question?

Thanks a lot
Jan 15, 2008 at 3:05 AM
I saved my excel 2003 file as an excel 2007 xlsx. The file size was reduced from 674K to 350K. However, I still could not read it and obtain the following mistake.

21:37:54 Load from Excel2007 file
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to all
ocate 6648 bytes) in C:\Program Files\PHP\Classes\PHPExcel\Style\Color.php on li
ne 590

The color.php only has 255 lines.

I used $objPHPExcel = $objReader->load("test.xlsx") from the sample provided. Does it mean I can't edit a file bigger than 130K using this method? Are there any other ways? Can anybody kindly answer my question?

Thanks a lot
Coordinator
Jan 15, 2008 at 8:34 AM
I'm affraid this is indeed the case. Some Excel files of larger filesize can be edited, but some can't.
Coordinator
Jan 15, 2008 at 12:37 PM
If you have access to your php.ini file to make configuration changes, then increasing the memory_limit parameter will allow you to load larger files
Jan 15, 2008 at 1:54 PM
I even tripled the memory limit in php.ini, but it doesn't work. I guess Maartenba is right. Some large files can be edited, some not. However, I found it is interesting, maybe I am wrong, that it seems that large files saved as xlsx from EXCEL 2003 are not editable, but large files directly from EXCEL 2007 are editable.
Coordinator
Jan 15, 2008 at 7:27 PM
Can you send me the Office2003-XLSX file you are trying to edit? (maarten AT name of this project (phpexcel) dot net)
Jan 24, 2008 at 9:01 AM
Hi !

I have the same problem and exactly the same error as Torontohrb.

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to all
ocate 6648 bytes) in C:\wamp\www\...\PHPExcel\Style\Color.php on li
ne 590

My file is an Excel2003 save as xslx (file size : 1.9Mb)

Have you find any solution since Jan 15 ? Is it possible to edit a big Excel2003 file save as xslx ?
Do you know an other solution to edit Excel files ?
Coordinator
Jan 24, 2008 at 2:16 PM
Can you send me the file? (email address earlier in this thread)