xlsx

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 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 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 Download Excel Files In The Browser In PHP Using PHPSpreadSheet Build a spreadsheet with PhpSpreadsheet and send it straight to the browser as a file download, without ever writing it to disk. The script streams the workbook in… July 18, 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