Author: admin

Prevent Formula Injection In Excel Exports In PHP Using PHPSpreadSheet A user-supplied value that starts with =, +, - or @ becomes a live formula when the file is opened. See how PhpSpreadsheet triggers formula injection by default,… August 7, 2026 · PhpSpreadsheet Create An Excel Table In PHP Using PHPSpreadSheet An Excel Table is more than styled cells — it is a named object with filter dropdowns, banded rows and structured references. Build one with PhpSpreadsheet's Table and… August 6, 2026 · PhpSpreadsheet Use VLOOKUP In Excel Files In PHP Using PHPSpreadSheet VLOOKUP searches the first column of a table and returns a value from the same row. Write one across a lookup table with PhpSpreadsheet, get the absolute-versus-relative references… August 6, 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 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