Download the PHP package alexandrainst/php-xlsx-fast-editor without Composer
On this page you can find all versions of the php package alexandrainst/php-xlsx-fast-editor. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download alexandrainst/php-xlsx-fast-editor
More information about alexandrainst/php-xlsx-fast-editor
Files in alexandrainst/php-xlsx-fast-editor
Package php-xlsx-fast-editor
Short Description PHP library to make basic but fast read & write operations on existing Excel workbooks
License LGPL-3.0-or-later
Homepage https://github.com/alexandrainst/php-xlsx-fast-editor
Informations about the package php-xlsx-fast-editor
php-xlsx-fast-editor
PHP library to make basic but fast read & write operations on existing Excel workbooks.
It handles XLSX/XLSM documents (Microsoft Excel 2007+, Office Open XML Workbook) using fast and simple low-level ZIP & XML manipulations, without requiring any library dependency, while minimising unintended side-effects.
Rationale
If you need advanced manipulation of Excel documents such as working with styles,
check the PhpSpreadsheet library
(previously PHPExcel),
but for simply reading & writing basic values from existing Excel workbooks, PhpSpreadsheet
is over an order of magnitude too slow,
and has the risk of breaking some unsupported Excel features such as some notes and charts.
There are also libraries to create new Excel documents from scratch, or for just reading some values, but not any obvious one for editing.
php-xlsx-fast-editor
addresses the need of quickly reading & writing & editing existing Excel documents,
while reducing the risk of breaking anything.
Note that to create a new document, you can just provide a blank or template Excel document as input.
Use
Via Composer:
or manually:
Examples
Tips
- ℹ️ Iterators (
$x->rowsIterator()
,$row->cellsIterator()
) and navigation methods ($cell->getNextCell()
, etc.) are much faster than accessing multiple rows or cells by direct access ($x->readString($worksheetId, 'A1')
, etc.), by name ($row->getCellOrNull('A')
), or by number ($x->getRow($worksheetId, 1)
).
Requirements
PHP 8.0+ with ZIP and XML extensions.
Check composer.json
for details.
Credits
Originally written by Alexandre Alapetite for the Alexandra Institute, 2023. License GNU LGPL.
All versions of php-xlsx-fast-editor with dependencies
ext-ctype Version *
ext-dom Version *
ext-xml Version *
ext-zip Version *