onurb/excel-bundle

Symfony Bundle to read or write Excel file (including pdf, xlsx, odt), using phpoffice/phpspreadsheet library (replacement of phpoffice/phpexcel, abandonned)

Symfony Excel bundle

, _(*1)

Installation

1 Add to composer.json to the require key, _(*2)

``` shell composer require onurb/excel-bundle, <sub>(*3)</sub>

or manually in composer.json
```json
    ...,
    "require": {
            ...,
            "onurb/excel-bundle":     "~1.0"
        },
    ...

2 Symfony 3 : Register the bundle in app/AppKernel.php ``` php $bundles = array( // ... new \Onurb\Bundle\ExcelBundle\OnurbExcelBundle(), );, <sub>(*4)</sub>

Symfony 4 : With symfony flex, bundle should be already automatically registered :
 ``` php
    // config/bundles.php
     return [
         // ...
         Onurb\Bundle\ExcelBundle\OnurbExcelBundle::class => ['all' => true],
     ];
 ```

## Usage

#### Create a spreadsheet
``` php
$spreadsheet = $this->get('phpspreadsheet')->createSpreadsheet();

Create a spreadsheet from an existing file

``` php $spreadsheet = $this->get('phpspreadsheet')->createSpreadsheet('file.xlsx');, <sub>(*5)</sub>

#### Create a Excel5 and write to a file given the object:

```php
$writer = $this->get('phpspreadsheet')->createWriter($spreadsheet, 'Xls');
$writer->save('file.xls');

Create a Excel 2007 and create a StreamedResponse:

$writer = $this->get('phpspreadsheet')->createWriter($spreadsheet, 'Xlsx');
$response = $this->get('phpspreadsheet')->createStreamedResponse($writer);

Create a Excel file with an image:

$writer = $this->get('phpspreadsheet')->createSpreadSheet();
$writer->setActiveSheetIndex(0);
$activesheet = $writer->getActiveSheet();
$drawingobject = $this->get('phpspreadsheet')->createSpreadsheetWorksheetDrawing();
$drawingobject->setPath('/path/to/image')
    ->setName('Image name')
    ->setDescription('Image description')
    ->setHeight(60)
    ->setOffsetY(20)
    ->setCoordinates('A1')
    ->setWorksheet($activesheet);

Create reader

$reader = $this->get('phpspreadsheet')->createReader('Xlsx');

Supported file types

Types are case sensitive. Supported types are: * Xlsx: Excel 2007 * Xls: Excel 5 * Xml: Excel 2003 XML * Slk: Symbolic Link (SYLK) * Ods: Libre Office (ODS) * Csv: CSV * Html: HTML, <sub>(*6)</sub>

Optional libraries can be installed for writing:

• Tcpdf
• Mpdf
• Dompdf

to install these libraries :, <sub>(*7)</sub>

composer require tecnick.com/tcpdf
composer require mpdf/mpdf
composer require dompdf/dompdf

liuggio/Excelbundle portability

For users already using liuggio/ExcelBundle wanting to migrate to phpspreadsheet, the bundle should be directly compatible : old phpexcel file types are maintained, a compatibility factory has been added, and the phpexcel service is also redeclared., <sub>(*8)</sub>

More

See also the official PhpSpreadsheet documentation., <sub>(*9)</sub>