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
Insert Rows And Columns In A Google Sheet Using Google Sheets API PHP Client
August 17, 2026
Add Conditional Formatting In A Google Sheet Using Google Sheets API PHP Client
August 16, 2026
Freeze Rows And Columns In A Google Sheet Using Google Sheets API PHP Client
August 16, 2026
Translate Excel Formulas Into Another Language In PHP Using PHPSpreadSheet
August 16, 2026
Format Google Sheets Cells Using Google Sheets API PHP Client
August 15, 2026
Write Reusable Formulas With The LAMBDA Function And LET
August 15, 2026
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
Browse by technique