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 Page Margins Settings In PHP Using PHPSpreadSheet
July 18, 2020
Create Excel Files With Page Orientation And Paper Size Settings In PHP Using PHPSpreadSheet
July 18, 2020
Create Excel Files With Explicit Cell Datatype In PHP Using PHPSpreadSheet
July 12, 2020
Create Excel Files With Line Breaks In PHP Using PHPSpreadSheet
July 12, 2020
Create Excel Files With Formulas In PHP Using PHPSpreadSheet
July 11, 2020
Create Excel Files With Date And Time Data In PHP Using PHPSpreadSheet
July 11, 2020
Set Metadata Of Excel Files In PHP Using PHPSpreadSheet
July 11, 2020
Create Excel Files With Italic Texts In PHP Using PHPSpreadSheet
June 28, 2020
Create Excel Files With Bold Texts In PHP Using PHPSpreadSheet
June 28, 2020
Browse by technique