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 Date Range Data Validation
August 21, 2020
Create Xlsx Files With Past Date Data Validation
August 17, 2020
Create Xlsx Files With Future Date Data Validation
August 16, 2020
Create Xlsx Files With Cell Data Validation Settings
August 15, 2020
Create Xlsx Files Excluding Certain Cells From Protection
August 11, 2020
Create Xlsx Files With Selected Cell Security Settings
August 9, 2020
Create Xlsx Files With Worksheet Security Settings
August 9, 2020
Create Xlsx Files with Document Security Settings
August 9, 2020
Create Xlsx Files With Auto Filter Settings
August 8, 2020
Browse by technique