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
Write Excel Files Data Horizontally In PHP Using PHPSpreadSheet
July 28, 2022
Merge Cells
July 25, 2022
Write Cell Data Horizontally
July 24, 2022
Write Google Sheets Data To A Single Range Horizontally Using Google Sheets API PHP Client
July 24, 2022
Change A Spreadsheet Title
July 24, 2022
Change Google Spreadsheet Title Using Google Sheets API PHP Client
July 23, 2022
Create A “Hello World” SpreadSheet Using Google Sheets API PHP Client
July 17, 2022
Create A Blank SpreadSheet Using Google Sheets API PHP Client Library
July 13, 2022
Obtain Google API Access Token Through Command Line Using PHP
July 10, 2022
Browse by technique