akeneo-labs/spreadsheet-parser-bundle

Akeneo spreadsheet parser bundle

Maintainers

Details

github.com/akeneo-labs/SpreadsheetParserBundle

Homepage

Source

Issues

Installs: 10 372

Dependents: 2

Suggesters: 0

Security: 0

Stars: 4

Watchers: 19

Forks: 2

Open Issues: 0

Type:symfony-bundle

v1.1.2 2015-10-05 08:35 UTC

Requires

OSL-3.0 0b81f3bc5a4860e427e85dba59eaceb12f0ae144

excelspreadsheetxlsxparserreaderakeneo

This package is auto-updated.

Last update: 2024-11-20 23:14:56 UTC

README

This component is designed to extract data from spreadsheets, while being easy on resources, even for large files.

The actual version of the spreadsheet parser only works with xlsx files.

Installing the bundle

From your application root:

$ php composer.phar require --prefer-dist "akeneo-labs/spreadsheet-parser-bundle"

You will then have to add the bundle to your AppKernel :

$bundles[] = new Akeneo\Bundle\SpreadsheetParserBundle\AkeneoSpreadsheetParserBundle();

Usage

To extract data from a spreadsheet, use the following code:

<?php

[...]

class MyService implements ContainerAwareInterface
{
    public method readSpreadsheet()
    {
        $loader = $this->container->get('akeneo_spreadsheet_parser.spreadsheet_loader');
        $spreadsheet = $loader->open('myfile.xlsx');

        $myWorksheetIndex = $spreadsheet->getWorksheetIndex('myworksheet');

        foreach ($spreadsheet->createRowIterator($myWorksheetIndex) as $rowIndex => $values) {
            var_dump($rowIndex, $values);
        }
    }

    [...]
}