A Symfony2 bundle for creating, modifying, and reading Excel files using the PHPOffice/PHPExcel library.
liuggio/ExcelBundle is a Symfony2 bundle that integrates PHPExcel into Symfony applications, providing a streamlined way to work with Excel files directly within the Symfony framework. It simplifies common spreadsheet operations like generation, reading, and manipulation through a service-oriented API, enabling developers to handle Excel files as part of their Symfony workflow.
Symfony2 developers who need to generate, read, or manipulate Excel files (e.g., for data exports, reports, or imports) within their Symfony-based web applications.
Developers choose this bundle because it offers a clean, testable integration layer that makes PHPExcel's powerful features accessible via Symfony's dependency injection, promoting simplicity and maintainability. It provides a service-oriented API that abstracts complex Excel operations, supports multiple formats (Excel5, Excel2007, CSV, HTML, etc.), and includes features like streamed responses for web delivery and image embedding.
Excel integration in Symfony2 thanks to https://github.com/PHPOffice/PHPExcel library
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Provides a clean, service-oriented API via Symfony's dependency injection, making Excel operations easily injectable and testable in controllers and services, as demonstrated in the TL;DR examples.
Supports various spreadsheet formats including Excel5, Excel2007, CSV, HTML, and OOCalc, allowing flexible export and import options, with a full list provided in the README.
Enables creation of downloadable Excel files as Symfony StreamedResponse objects, which is efficient for web applications by avoiding memory issues with large file generation.
Allows embedding images into worksheets with customizable positioning and sizing through a dedicated drawing object service, as shown in the code snippet for image insertion.
PHPExcel is deprecated and replaced by PhpSpreadsheet; this bundle may not receive updates for new Excel standards or security patches, limiting long-term viability.
Version 2 introduces significant backward compatibility breaks from version 1, requiring code refactoring for upgrades, as explicitly warned in the README.
The README is sparse and primarily points to external examples or the PHPExcel repository; it lacks comprehensive guides, API documentation, or troubleshooting resources.