Cookbook
Integrate phpxlsx with Symfony
Warning
To run phpxlsx with Symfony it is mandatory to use the package that supports namespaces. This package is available for Advanced and Premium licenses.
The installation of phpxlsx in a project that works with Composer can be manual or using a private repository with GitHub, Bitbucket or any other distributed version control system.
In order to use a private repository with GitHub or Bitbucket, you have to generate and use an SSH key:
- GitHub: https://stackoverflow.com/questions/40619393/how-to-add-private-github-repository-as-composer-dependency
- Bitbucket: https://dev.to/minompi/using-a-bitbucket-private-repository-in-your-projects-24j9
To perform a manual integration just follow these easy steps:
- 1- Copy the content of the phpxlsx package in the folder vendor/phpxlsx.
- 2- Open the file composer.json. Add the following classmap in the autoload section:
"vendor/phpxlsx/Classes/Phpxlsx"
In a Symfony 4, Symfony 5 and Symfony 6 clean installation, the section should look like this:
- 3- Update the autoloader of Composer:
Now, with these three easy steps completed, you can work with phpxlsx.
As an example, let's create a XLSX in a controller, and then save it in a public folder with the name output.xlsx: