Registry / serialization / phpoffice-phpspreadsheet

phpoffice-phpspreadsheet

JSON →
library5.8.0phppackagistunverified

A PHP library for reading, creating, and writing spreadsheet documents in various formats.

composer require phpoffice/phpspreadsheet
INSTALL
IMPORT
SIG · PHPOFFICE-PHPSPREA
P
phpoffice-phpspreadsheet
serializationphpv5.8.0
harness data pending
Install & Compatibility
Where this runs

No compatibility data collected yet for this library.

Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

Spreadsheet
use PhpOffice\PhpSpreadsheet\Spreadsheet;

Create a simple spreadsheet and save it as XLSX.

use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World!'); $writer = new Xlsx($spreadsheet); $writer->save('hello_world.xlsx');
Debug
Known issues
gotchaMemory usage can be high for large spreadsheets; consider using PhpOffice\PhpSpreadsheet\Reader\Xlsx with setReadDataOnly(true) for reading.
fix
Use chunked reading or setReadDataOnly(true) to reduce memory footprint.
affects: *
Upgrade
Version history
5.8.0latest on Packagist
Audit
Dependencies

No dependency data recorded yet.

Agent activity
7 hits · last 30 days
node
6
Resources
phpoffice-phpspreadsheet — pip install phpoffice-phpspreadsheet · libregistry