IOFactory

Guard Against XXE When Reading An Untrusted Excel File In PHP Using PHPSpreadSheet An .xlsx is a ZIP full of XML, so reading one from a stranger means parsing hostile XML on your own server. PhpSpreadsheet’s XmlScanner is already on by… August 10, 2026 · PhpSpreadsheet Reject A Corrupt Or Unreadable Excel File In PHP Using PHPSpreadSheet IOFactory::identify() reports which reader would try, not that the file will actually load. This article manufactures four broken workbooks, watches the usual approach die on the one that… August 10, 2026 · PhpSpreadsheet Read Excel Dates Back Into PHP Using PHPSpreadSheet A date cell reads back as a serial number like 46095, not a date — Excel stores days from an epoch and paints a format over them. This… August 6, 2026 · PhpSpreadsheet Convert An Excel File To XML In PHP Using PHPSpreadSheet Treat the first row as headers and turn every data row into an XML record, using PHP's XMLWriter so ampersands and angle brackets are escaped for you —… August 5, 2026 · PhpSpreadsheet Convert An Excel File To An HTML Table In PHP Using PHPSpreadSheet This article shows how to convert an Excel file into an HTML table with the latest version of PhpSpreadsheet using plain PHP. The point of doing it in… July 31, 2026 · PhpSpreadsheet Convert An Excel File To CSV In PHP Using PHPSpreadSheet This article shows how to convert an Excel file to CSV with the latest version of PhpSpreadsheet using plain PHP. Reading the workbook is the easy half —… July 29, 2026 · PhpSpreadsheet Import Excel Files Into MySQL In PHP Using PHPSpreadSheet This article shows how to read an Excel file with PhpSpreadsheet and load its rows into a MySQL table. The first row of the spreadsheet is treated as… July 19, 2026 · PhpSpreadsheet How to Convert an Excel File to JSON Using PhpSpreadsheet This article shows how to read an Excel file with the latest version of PhpSpreadsheet and convert it into a JSON file using plain PHP. The first row… July 17, 2026 · PhpSpreadsheet