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 Save One Spreadsheet As XLSX, XLS And ODS In PHP Using PHPSpreadSheet A Spreadsheet object is format-independent — the format is decided only when a writer serialises it. Build the workbook once and save it as .xlsx, .xls and .ods… August 4, 2026 · PhpSpreadsheet Use Named Ranges In Excel Files In PHP Using PHPSpreadSheet A named range lets a formula say =SUM(Amounts) instead of =SUM($B$2:$B$5), so it reads like a sentence and the reference lives in one place. This defines a range… August 3, 2026 · PhpSpreadsheet Add Rich Text To A Single Cell In Excel Files In PHP Using PHPSpreadSheet A plain string cell carries a single font, so one word cannot be bold and red while the rest stays normal. A RichText object, built from separate styled… August 2, 2026 · PhpSpreadsheet List The Worksheets In An Excel File In PHP Using PHPSpreadSheet This article shows how to list the worksheets in an Excel file, and load only the one you want, with the latest version of PhpSpreadsheet using plain PHP.… August 1, 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 Loop Through Cells With Iterators In PHP Using PHPSpreadSheet This article shows how to loop through the cells of a worksheet with the row and cell iterators in the latest version of PhpSpreadsheet using plain PHP. toArray()… July 30, 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 Handle An Uploaded Excel File In PHP Using PHPSpreadSheet This article shows how to accept an Excel file uploaded from an HTML form and read it with the latest version of PhpSpreadsheet using plain PHP. Reading the… July 28, 2026 · PhpSpreadsheet