Articles tagged: #php

FastExcelReader 4 reads the old XLS format (Excel 97–2003) through exactly the same methods you already use for XLSX — no second library, no branching in your code. withHeader() now accepts your own column names, and XLSX reading got about 1.5 times faster. A walkthrough of what version 4 brings.

PhpSpreadsheet burns hundreds of megabytes even on small files and dies outright on large ones. If your job is to read data out of Excel rather than edit a workbook, there is a sharper tool: FastExcelReader streams XLSX and CSV — fast and with almost flat memory — without losing dates, styles, merged cells or images. An overview of the reader.