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 Excel Files With Average Formula In PHP Using PHPSpreadSheet
April 29, 2023
Create Excel Files With Sum Formula In PHP Using PHPSpreadSheet
April 26, 2023
Duplicate Google Sheets Sheet Using Google Sheets API PHP Client
April 23, 2023
Update Google Sheets Cells Using Google Sheets API PHP Client
April 22, 2023
Unmerge Google Sheets Cells Using Google Sheets API PHP Client
April 22, 2023
What is PHP Excel
April 21, 2023
Merge Google Sheets Cells Using Google Sheets API PHP Client
March 20, 2023
Change Google Sheets Border Using Google Sheets API PHP Client
February 25, 2023
Write Google Sheets Data To A Multiple Range Horizontally Using Google Sheets API PHP Client
August 10, 2022
Browse by technique