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
getActiveSheet()
PhpSpreadsheet
fromArray()
PhpSpreadsheet
getCalculatedValue()
PhpSpreadsheet
save('php://output')
PhpSpreadsheet
spreadsheets_values->get()
Google Sheets
spreadsheets_values->update()
Google Sheets
spreadsheets->create()
Google Sheets
json_encode()
PHP
header()
PHP
Latest articles
Replace Fill Down With The ARRAYFORMULA Function In Google Sheets
August 15, 2026
Pull Live Data Into Google Sheets With The IMPORT Functions
August 14, 2026
Replace VLOOKUP With The XLOOKUP Function In Google Sheets
August 14, 2026
Combine The FILTER Function With SORT And UNIQUE In Google Sheets
August 14, 2026
Write SQL In A Cell With The Google Sheets QUERY Function
August 13, 2026
Clear The Formula Calculation Cache In PHP Using PHPSpreadSheet
August 13, 2026
Control Cell Data Types With Value Binders In PHP Using PHPSpreadSheet
August 13, 2026
Import An Excel File Into Google Sheets Using Google Sheets API PHP Client
August 12, 2026
Delete Google Sheets Rows And Clear Ranges Using Google Sheets API PHP Client
August 12, 2026
Browse by technique