Rich ID Excel Generator Bundle

Quickly and easily generate complex Excel files hydrated with your own data with style.

Quick start

The Excel is built from 3 different models: the spreadsheet, a sheet and a content.

• The spreadsheet contains only the filename, and a list of sheets
• A sheet has only a name and a list of child
• A child is often a custom class that extends from the ExcelContent class to hydrate the content

This is an example of a custom content that has some children. Any children will take its own row, which is very handy for recursion.

use RichId\ExcelGeneratorBundle\Annotation as Excel;
use RichId\ExcelGeneratorBundle\Model\ExcelContent;

/**
 * @Excel\HeaderStyle(color="#FFFFFF", backgroundColor="#C1D9E1", fontSize=18, position=Excel\Style::POSITION_CENTER)
 */
class PersonContent extends ExcelContent
{
    /**
     * @var string
     *            
     * @Excel\ContentStyle(color="#000000", fontSize=12, wrapText=true)
     * @Excel\HeaderTitle(title="app.person.firstname")
     */
   public $firstname;
   
    /**
     * @var string
     *            
     * @Excel\ContentStyle(color="#000000", fontSize=12, bold=true, wrapText=true)
     * @Excel\HeaderTitle(title="app.person.lastname")
     */
   public $lastname;
   
    /**
     * @var string
     *            
     * @Excel\ContentStyle(color="#000000", fontSize=10)
     * @Excel\HeaderTitle(title="app.person.age")
     */
   public $age;
   
   public function __construct(User $user)
   {
        $this->firstname = $user->getFirstname();
        $this->lastname = $user->getLastname();
        $this->age = $user->getAge();
        
        foreach ($user->getAddresses() as $address) {
            $addressContent = new AddressContent($address);
            $this->addChild($addressContent);
        }
   }
}

Table of content

1. Installation
2. Configuration
   • Columns
   • Headers
   • Styles
3. Versioning
4. Contributing
5. Hacking
6. License

1. Installation

This version of the bundle requires Symfony 4.4+ and PHP 7.3+.

composer require rich-id/excel-generator-bundle

2. Configuration

• Columns
• Headers
• Styles

3. Versioning

excel-generator-bundle follows semantic versioning. In short the scheme is MAJOR.MINOR.PATCH where

1. MAJOR is bumped when there is a breaking change,
2. MINOR is bumped when a new feature is added in a backward-compatible way,
3. PATCH is bumped when a bug is fixed in a backward-compatible way.

Versions bellow 1.0.0 are considered experimental and breaking changes may occur at any time.

4. Contributing

Contributions are welcomed! There are many ways to contribute, and we appreciate all of them. Here are some of the major ones:

• Bug Reports: While we strive for quality software, bugs can happen and we can't fix issues we're not aware of. So please report even if you're not sure about it or just want to ask a question. If anything the issue might indicate that the documentation can still be improved!
• Feature Request: You have a use case not covered by the current api? Want to suggest a change or add something? We'd be glad to read about it and start a discussion to try to find the best possible solution.
• Pull Request: Want to contribute code or documentation? We'd love that! If you need help to get started, GitHub as documentation on pull requests. We use the "fork and pull model" were contributors push changes to their personal fork and then create pull requests to the main repository. Please make your pull requests against the master branch.

As a reminder, all contributors are expected to follow our Code of Conduct.

5. Hacking

You might use Docker and docker-compose to hack the project. Check out the following commands.

# Start the project
docker-compose up -d

# Install dependencies
docker-compose exec application composer install

# Run tests
docker-compose exec application bin/phpunit

# Run a bash within the container
docker-compose exec application bash

6. License

excel-generator-bundle is distributed under the terms of the MIT license.

See LICENSE for details.