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.
Latest complete code
<?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Worksheet\Table; use PhpOffice\PhpSpreadsheet\Worksheet\Table\TableStyle; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $worksheet = $spreadsheet->getActiveSheet(); $worksheet->setTitle('Sales'); $worksheet->fromArray([ ['Region', 'Rep', 'Units', 'Revenue'], ['North', 'Alice', 120, 4800], ['South', 'Bob', 90, 3600], ['East', 'Carol', 150, 6000], ['West', 'Dan', 70, 2800], ], null, 'A1'); // The Table object: a range plus a unique workbook name. $table = new Table('A1:D5', 'SalesData'); // A built-in style: banded rows, shaded header, filter dropdowns. $tableStyle = new TableStyle(); $tableStyle->setTheme(TableStyle::TABLE_STYLE_MEDIUM2); $tableStyle->setShowRowStripes(true); $table->setStyle($tableStyle); $worksheet->addTable($table); (new Xlsx($spreadsheet))->save('sales-table.xlsx'); echo "Wrote sales-table.xlsx\n\n"; foreach ($worksheet->getTableCollection() as $t) { echo "Table name : " . $t->getName() . "\n"; echo "Range : " . $t->getRange() . "\n"; echo "Style : " . $t->getStyle()->getTheme() . "\n"; echo "Row stripes: " . ($t->getStyle()->getShowRowStripes() ? 'yes' : 'no') . "\n"; }
The full script from Create An Excel Table In PHP Using PHPSpreadSheet — copy, run, 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 An Excel Table In PHP Using PHPSpreadSheet
August 6, 2026
Use VLOOKUP In Excel Files In PHP Using PHPSpreadSheet
August 6, 2026
Read Excel Dates Back Into PHP Using PHPSpreadSheet
August 6, 2026
Convert An Excel File To XML In PHP Using PHPSpreadSheet
August 5, 2026
Save One Spreadsheet As XLSX, XLS And ODS In PHP Using PHPSpreadSheet
August 4, 2026
Use Named Ranges In Excel Files In PHP Using PHPSpreadSheet
August 3, 2026
Add Rich Text To A Single Cell In Excel Files In PHP Using PHPSpreadSheet
August 2, 2026
List The Worksheets In An Excel File In PHP Using PHPSpreadSheet
August 1, 2026
Convert An Excel File To An HTML Table In PHP Using PHPSpreadSheet
July 31, 2026
Browse by technique