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 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 Convert HTML Table Into Excel Convert a table from an HTML file into an excel file with PHP using PHPSpreadSheet. Import an HTML table into an excel file using PHPSpreadSheet. Maintain the same… July 16, 2023 · PhpSpreadsheet Create a Grocery List Template in Excel Learn How to Create a Grocery List Template in Excel with PHP using PHPSpreadSheet. List down and organize all your grocery item needs before doing a shopping to… May 14, 2023 · PhpSpreadsheet Insert Pictures In Excel Files In PHP Using PHPSpreadSheet Learn how to insert pictures in excel files in PHP using PHPSpreadSheet. You can insert pictures in excel files by creating a new Drawing object and then set… May 6, 2023 · PhpSpreadsheet