PhpSpreadsheet

Set Sheet View Options In Excel Files In PHP Using PHPSpreadSheet Zoom level, the selected cell and right-to-left layout decide what a reader sees in the first second after double-clicking your file, without changing a single value inside it.… August 8, 2026 · PhpSpreadsheet Set The Worksheet Tab Color In Excel Files In PHP Using PHPSpreadSheet Once a workbook holds more than three or four sheets the tab strip becomes the navigation, and coloring it is one call per sheet with getTabColor()->setRGB(). Two things… August 8, 2026 · PhpSpreadsheet Rotate Text In A Cell In Excel Files In PHP Using PHPSpreadSheet Tilting a header row 45 degrees is a single call to getAlignment()->setTextRotation(), and it saves you from either stretching every column to the width of its title or… August 8, 2026 · PhpSpreadsheet Add Data Bars, Color Scales And Icon Sets In Excel Files In PHP Using PHPSpreadSheet Data bars, color scales and icon sets are the graphical conditional formats: the bar filling each cell, the red-to-green heat map, the row of traffic lights. They use… August 7, 2026 · PhpSpreadsheet Sort Rows Before Writing An Excel File In PHP Using PHPSpreadSheet PhpSpreadsheet has no sort() method and never has, because a worksheet is a grid of cells rather than a list of records. You sort the PHP array first… August 7, 2026 · PhpSpreadsheet 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