Memory model

xlswriter offers two memory strategies for writing files:

  • Normal mode — the entire workbook is held in memory; fastest but proportional to data size.

  • Fixed memory mode — rows are flushed to disk as they are written, keeping peak memory under ~1 MB regardless of file size. Recommended for exporting millions of rows.

Pick fixed memory mode whenever the dataset may not fit comfortably in PHP's memory_limit.

Last updated