How to Stop PHPExcel Exports from Timing Out or Exhausting Memory

Introduction

PHP developers frequently need to export data from backend systems, and the common solution is the open‑source PHPExcel library. In practice, export operations often encounter timeout or out‑of‑memory errors, which frustrates business users.

Memory‑Related Causes

When the exported file contains many rows and columns, its size grows, consuming more memory. PHP's memory_limit (set in php.ini) restricts usage, and PHPExcel stores data in memory by default, causing failures once the limit is exceeded. Richer data formats also increase memory consumption.

PHPExcel uses an average of about 1 KB per cell, so large workbooks can quickly use up available memory. Cell caching allows PHPExcel to keep cell objects in a smaller memory footprint, on disk, or in APC, Memcache, or WinCache, reducing memory usage at the cost of access speed.

Since version 1.7.3, PHPExcel supports cell caching, enabling storage in caches such as Memcache. The cache mode must be set before creating the PHPExcel object, and the relevant code can be found in PHPExcel/CachedObjectStorageFactory.php. For example, to use Memcache, configure the cache accordingly (see PHPExcel/CachedObjectStorage/Memcache.php for key structure).

Code Optimization

PHP follows a reference‑counting and copy‑on‑write memory model. To avoid waste, especially when handling arrays, use memoization, promptly unset unused variables, and avoid building a single massive array for export. If the dataset exceeds available memory, consider splitting the export by time range or other dimensions.

Timeout‑Related Causes

Key timeout factors when using PHPExcel with Nginx include: max_execution_time in php.ini – counts only PHP script execution time, not I/O or sleep. request_terminate_timeout in php-fpm.conf – truly limits CGI‑SAPI execution; a value of 0 means unlimited.

Nginx fastcgi parameters (see diagram below).

Apache’s httpd.conf also defines a timeout for CGI scripts.

Comprehensive Solution

Combine cell caching with an asynchronous queue to handle large exports. Generate a unique export ID, let the client poll for the file URL via AJAX, and process the export in the background. Create one queue per system (e.g., crmExportQueue) to simplify management and avoid idle queues.

This approach dramatically improves user experience and prevents both timeout and memory exhaustion during PHPExcel exports.