Re:Show HN: Xezilaires – a simple PHP library to read struct...
by dkarlovi on Saturday August 24, 2019 @06:49AM
(#20786438)
A lot of businesses use Excel as their means of storing and exchanging any sort of structured data.
This PHP library allows you to define a PHP class and a mapping (using column names or header labels) how you'd like to transform the said Excel into the PHP value object. Then you iterate the Excel sheet one row at a time and get a PHP object for each row, which you can for example store to the DB via an ORM.
Since it's using Symfony Serializer, you can also create custom denormalizers, like converting a random date-ish string into an instance of \DateTime.
More features (like validation, proper streaming serializers for very large data sets, etc) are planned.
This PHP library allows you to define a PHP class and a mapping (using column names or header labels) how you'd like to transform the said Excel into the PHP value object. Then you iterate the Excel sheet one row at a time and get a PHP object for each row, which you can for example store to the DB via an ORM.
Since it's using Symfony Serializer, you can also create custom denormalizers, like converting a random date-ish string into an instance of \DateTime.
More features (like validation, proper streaming serializers for very large data sets, etc) are planned.