Code examples for the tutorial How to Read and Write Excel Files in PHP?.
The code is packaged as a simple Symfony application with cli commands.
This series also proposes other PHP data integration tutorials:
- How to Read and Write CSV Files in PHP?
- How to Read, Decode, Encode, and Write JSON Files in PHP?
- How to Use Google Sheets API in PHP?
Download the source code:
git clone git@github.com:nidup/manipulate-excel-data-in-php.git
cd manipulate-excel-data-in-php
Then the installation comes into 2 flavors, directly on your host or using docker.
Once installed the commands are the same, some docker shortcuts are provided in .docker/bin
.
Install the PHP dependencies:
composer install
Build the docker image and install the PHP dependencies:
docker-compose up -d
.docker/bin/composer install
Use bin/console
or .docker/bin/console
to launch a command.
List the commands:
bin/console --env=prod
[...]
nidup
nidup:excel:generate-big-file Generate a 1M lines excel file (with box/spout)
nidup:excel:read-big-file Read a big excel file and measure time and memory (with box/spout)
nidup:excel:read-file Read an excel file (with box/spout)
nidup:excel:write-file Write an excel file (with box/spout)
[...]
Launch a command:
bin/console nidup:excel:read-file --env=prod
We use the prod environment here to have the most efficient execution.