Export to Excel Issues w/ v8

Applications Grid / Reports
#1

I converted my apps to v8 this past week, and have found an issue when trying to export to Excel on some grids. I had some issues in the past with exporting large data sets to Excel, and it would time out and not show any errors. I am now showing an error that I don’t know what to do about.

When exporting, the following message shows (with varying amounts of bytes shown):
Fatal error: Allowed memory size of 157286400 bytes exhausted (tried to allocate 72 bytes) in /path/to/app/_lib/prod/third/phpexcel/PHPExcel/Style/Supervisor.php on line 123

I have changed php.ini settings max_limit and max_execution_time, but to no avail.

Anyone else seeing this error? I have done some Googling, but nothing found that makes sense yet.

Thanks.

#2

How many records are you trying to export?

#3

One of the reports that quickly fails is 574 records with ~100 columns. The CSV file size is 594KB. That one fails with: Allowed memory size of 157286400 bytes exhausted (tried to allocate 72 bytes)

Same report, but if I remove 50 columns from the report, it fails with: Allowed memory size of 157286400 bytes exhausted (tried to allocate 64 bytes)

Another report with 12683 records with ~40 columns fails with the same error message.

A report with 848 and 6 columns of data generates fine, as do most of the other smaller reports.

#4

Here is the error with memory_limit set to 250M:

Fatal error: Allowed memory size of 262144000 bytes exhausted (tried to allocate 33554432 bytes) in /home/blackhaw/public_html/core/_lib/prod/third/phpexcel/PHPExcel/Style/Supervisor.php on line 126

It appears with the large report - 574 records with ~100 columns, I can get 45 records to successfully export into Excel. Anything more than that I receive an error.

A different error that I got one time was:

Fatal error: Allowed memory size of 157286400 bytes exhausted (tried to allocate 72 bytes) in /path/to/app/_lib/prod/third/phpexcel/PHPExcel/CachedObjectStorage/CacheBase.php on line 173

That error has only shown a couple of times.

[edit] I have also removed the old /_lib/prod/third/phpexcel/ directory and re-uploaded all files. Nothing changed with the errors.

#5

I just rolled back the PHPExcel version to the one that was with v7 and these are working again.

The PHPExcel version from v7 is 1.7.6, and the version with v8 is 1.7.9.

After downgrading the PHPExcel, I am able to export all of the above reports. I see this as a temporary solution, so I would appreciate notice if anything is done on the 1.7.9 version to get it operational.

Thanks!

#6

I have same error when export to excel with 1000 records with ~50 columns.

#7

Not sure if PHPExcel was updated in the last update, but the version was updated with no change to the problem. The fatal error still exists. Rolling it back to the previous version fixes the problem.

#8

I got 12k++ data and might be more. Always result (500) server error. I tried use PHPExcel 1.7.6, Still the same. Anyone got any other idea to solve this issue?