PHPSpreadsheet · Google Sheets API · Excel

Spreadsheets, driven by code.

Hands-on PHP tutorials for working with Excel and Google Sheets — read and write .xlsx, convert files to JSON, stream downloads in the browser, and insert images, formulas, and styling. Every guide ships with code you can copy, run, and adapt.

Key methods

IOFactory::load() PhpSpreadsheet

Open any spreadsheet file

getActiveSheet() PhpSpreadsheet

Select the worksheet to fill

fromArray() PhpSpreadsheet

Write many rows at once

getCalculatedValue() PhpSpreadsheet

Read a formula result

save('php://output') PhpSpreadsheet

Stream the file as a download

spreadsheets_values->get() Google Sheets

Read a range of cells

spreadsheets_values->update() Google Sheets

Write a range of cells

spreadsheets->create() Google Sheets

Create a new spreadsheet

json_encode() PHP

Serialize rows to JSON

header() PHP

Send the download headers

Latest articles

Update Excel Files In PHP Using PHPSpreadSheet June 27, 2020 Unmerge Cells In Excel Files In PHP Using PHPSpreadSheet June 27, 2020 Merge Cells In Excel Files In PHP Using PHPSpreadSheet June 27, 2020 Create Excel Files With Text Links In PHP Using PHPSpreadSheet June 21, 2020 Create Excel Files With Underlined Texts In PHP Using PHPSpreadSheet June 21, 2020 Create Excel Files With Different Cell Font Colors In PHP Using PHPSpreadSheet June 21, 2020 Read Excel Files Cell Data Only In PHP Using PHPSpreadSheet June 21, 2020 Create Excel Files With Different Cell Background Colors In PHP Using PHPSpreadSheet June 21, 2020 Read Excel Files In PHP Using PHPSpreadSheet’s IOFactory Class June 21, 2020

Browse by technique

PhpSpreadsheetBuild & read .xlsx with PHP · 108 guides

Google Sheets API PHP ClientAutomate Google Sheets · 32 guides

SnippetsQuick copy-paste recipes · 5 guides

Excel → JSONConvert sheets to JSON

Browser downloadsStream files to the user

Formula resultsRead computed values