uklfr / json2xlsx
given a nested json a xlsx sheet is generated
Requires
- php: >7.0
- ozdemirburak/iris: ^2.5
- phpoffice/phpspreadsheet: ^1.18
Requires (Dev)
- vlucas/phpdotenv: ^5.5
README
This small framework allows to export 1:n data from sql and show them in one xlsx file. Therefore, we offer some loader functions as well as some formatting tools. This php package keeps very simple and is intended to visualize more complex data structures with the possibility to not display redundant data.
Installation
Just install the package using composer.
composer require uklfr/json2xlsx
Afterwards, we recommend to include vendor/autoload.php.
Usage
This packages offers 2 classes which are used to fetch and to format data. In example we prepared a fully featured and runnable use case which you can run by just checking out this repository.
Note: These examples do rely on relative paths in the repository. If you want to use this lib in production as composer package, we recommend to use the common way of the composer autoloading functionality.
Requirements
This package was tested and developed under PHP7 with the following extensions activated:
- php_zip
- php_xml
- php_gd2
With schmittr/php-json2xlsx we provide a php docker with
exactly these requirements. Maybe it would also work with PHP>=5.6, but we did not test this.
License
This software is distributed by MIT License.