Download the PHP package sigwin/xezilaires-dev without Composer
On this page you can find all versions of the php package sigwin/xezilaires-dev. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download sigwin/xezilaires-dev
More information about sigwin/xezilaires-dev
Files in sigwin/xezilaires-dev
Package xezilaires-dev
Short Description Iterate structured Excel spreadsheets, normalize rows into value objects, validate, serialize into CSV, JSON, XML
License MIT
Informations about the package xezilaires-dev
Xezilaires
Xezilaires is a PHP library which helps to iterate structured Excel spreadsheets, normalize rows into value objects, validate, serialize into CSV, JSON, XML.
What it does
- we create a PHP class which will hold our Excel row data
- we next create spreadsheet iterator instance
- passing the path to the Excel file we wish to read
- passing the configuration mapping the Excel columns into PHP properties
- as we're iterating, we are getting an value object (instance of the defined class) for each row
Think of it as an "ORM" (Object Relation Manager) for an Excel file. An OEM (Object Excel Manager), if you will.
Example usage
Without attributes
With attributes
See more examples in the docs/examples/
folder.
Options
start
, which row do we start on
(integer, optional, default:1
)header
, which row contains the header labels
(integer, optional if not usingHeaderReference
, default:null
)reverse
, do we iterate the rows in reverse, from end to start
(boolean, optional, default:false
)sequential
, is the key sequential (0, 1, 2) or represents current row?
(boolean, optional, default:false
)
Features
Features included:
- Reading Excel files
(using eitherphpoffice/PhpSpreadsheet
oropenspout/openspout
) - Denormalization / normalization support
(usingsymfony/serializer
, from / to all supported formats) - Attributes support
- mapping via column names or header labels
(saying "Map header labelPrdctEN
to propertyproduct
") - A Symfony bundle
(for easy integration into existing apps) - CLI (command-line interface) tool
Custom normalizers / validators
You can use your own normalizers / validators by passing your own Symfony bundle
which registers them to the Xezilaires commands via --bundle
, like so:
See example bundle in src/Xezilaires/Test/ExampleBundle/
.
What's with the name
xezilaires
is serializex
backwards.
We added the X so the name so we can shorten it as XLS. As a side-effect, we made reading Excel files with this library cool.
All versions of xezilaires-dev with dependencies
ext-json Version *
symfony/options-resolver Version ^6.4 || ^7.0
symfony/serializer Version ^6.4 || ^7.0