SpreadSheet-Coding.com

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.

save-formats.php View article
<?php

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Writer\Xls;
use PhpOffice\PhpSpreadsheet\Writer\Ods;

// Build ONE spreadsheet object. Nothing on it is tied to a file format.
$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();
$worksheet->setTitle('Report');

$worksheet->fromArray([
    ['Region', 'Units', 'Revenue'],
    ['North', 120, 4800],
    ['South', 90, 3600],
    ['East', 150, 6000],
], null, 'A1');

$worksheet->getStyle('A1:C1')->getFont()->setBold(true);
$worksheet->getStyle('C2:C4')->getNumberFormat()->setFormatCode('$#,##0');

// The SAME object, saved through three writers. Binary .xls before .ods.
(new Xlsx($spreadsheet))->save('report.xlsx');
(new Xls($spreadsheet))->save('report.xls');
(new Ods($spreadsheet))->save('report.ods');

foreach (['report.xlsx', 'report.xls', 'report.ods'] as $file) {
    printf("%-12s %6d bytes\n", $file, filesize($file));
}

The full script from Save One Spreadsheet As XLSX, XLS And ODS In PHP Using PHPSpreadSheet — copy, run, adapt.

IOFactory::load() PhpSpreadsheet
Open any spreadsheet file
getActiveSheet() PhpSpreadsheet
Select the worksheet to fill
fromArray() PhpSpreadsheet
Write many rows at once
getCalculatedValue() PhpSpreadsheet
Read a formula result
save('php://output') PhpSpreadsheet
Stream the file as a download
spreadsheets_values->get() Google Sheets
Read a range of cells
spreadsheets_values->update() Google Sheets
Write a range of cells
spreadsheets->create() Google Sheets
Create a new spreadsheet
json_encode() PHP
Serialize rows to JSON
header() PHP
Send the download headers