PhpSpreadsheet

Convert An Excel File To PDF In PHP Using PHPSpreadSheet Convert an Excel file to a PDF with PhpSpreadsheet by pairing it with the Dompdf renderer — load the workbook, hand it to the PDF writer, and save… July 27, 2026 · PhpSpreadsheet Freeze The Header Row In Excel Files In PHP Using PHPSpreadSheet Keep the header row of an Excel export in view while the rest scrolls, using PhpSpreadsheet's freezePane() — one line that turns a long, unreadable sheet into a… July 26, 2026 · PhpSpreadsheet Create An Excel Chart In PHP Using PHPSpreadSheet Add a real, editable column chart to an Excel file with PhpSpreadsheet — point a DataSeries at your cells, anchor the Chart on the sheet, and remember setIncludeCharts(true). July 25, 2026 · PhpSpreadsheet Work With Multiple Worksheets In Excel Files In PHP Using PHPSpreadSheet Build an Excel file with several worksheets: rename the first sheet, add more with createSheet(), give each its own data, and pick which tab is selected when the… July 24, 2026 · PhpSpreadsheet Convert A CSV File To Excel In PHP Using PHPSpreadSheet Read a CSV with PhpSpreadsheet's Csv reader — setting the delimiter, enclosure and encoding up front — then save it straight back out as a real .xlsx workbook. July 23, 2026 · PhpSpreadsheet Read Large Excel Files In Chunks In PHP Using PHPSpreadSheet This article shows how to read a large Excel file a few thousand rows at a time instead of all at once, using a read filter. Loading a… July 22, 2026 · PhpSpreadsheet Read Formula Results In Excel Files In PHP Using PHPSpreadSheet This article shows how to read what a formula in an Excel file actually works out to, rather than the formula itself. Reading a cell with getValue() returns… July 21, 2026 · PhpSpreadsheet Export MySQL Data To Excel Files In PHP Using PHPSpreadSheet This article shows how to run a query against MySQL and turn the result into a formatted .xlsx file with PhpSpreadsheet. The column names become the header row,… July 20, 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