Add editable charts to XLSX reports in pure PHP: quarterly line charts, pie charts, column-and-line combos, and a secondary axis. FastExcelWriter 6.17 examples include a four-chart dashboard.
Turn a raw XLSX export into a useful sales report with FastExcelWriter: style headers and data, set number formats and column widths, freeze headers, add filters, and build a summary sheet.
"The Excel file downloads but is corrupted" almost always means stray bytes around the ZIP. Here is how to send an XLSX to the browser properly: download()/output(), the reference headers, and recipes for Laravel and Symfony controllers.
Dates turn into 44898, leading zeros vanish from SKUs, card numbers become 8.98E+18. Those are not bugs — that is how Excel stores values. Learn to type your data correctly when exporting to XLSX with FastExcelWriter.
Does your Excel export die with an out-of-memory error on large data? The cause is the “whole workbook in memory” object model. Here is how to write a million rows to XLSX with flat memory use in plain PHP: FastExcelWriter's row → temp file → ZIP streaming scheme.
XLSX isn’t an “Excel document” — it’s a ZIP archive of XML files. This article breaks down the internals of the format and explains why streaming writes are fundamentally more efficient than the object model when generating large Excel files in PHP.
Generating Excel in PHP looks like a simple task — right up until the file grows to hundreds of thousands of rows and the script hits its memory limit or dies on a timeout. This is an article about the philosophy of FastExcelPhp and the problems this family of libraries solves.
Why do you need FastExcelWriter when the excellent PhpSpreadsheet already exists? Because it is simply better — faster, leaner and more concise.