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
Create Xlsx Files With Grouped Or Outlined Rows
March 13, 2022
Create Xlsx Files With Hidden Rows
March 13, 2022
Create Xlsx Files With Row Height Settings
September 11, 2021
Create Xlsx Files With Hidden Group Column Settings
September 5, 2021
Create Xlsx Files With Visible Group Column Settings
September 13, 2020
Create Xlsx Files With Auto Column Width Settings
September 5, 2020
Create Xlsx Files With Column Width Settings
September 5, 2020
Create Xlsx Files With Date Not In Range Data Validation
August 23, 2020
Create Xlsx Files With Drop Down List Data Validation
August 22, 2020
Browse by technique