2017 © Pedro Peláez
 

library spreadsheet-parser

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

image

akeneo/spreadsheet-parser

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  • Friday, July 29, 2016
  • by Akeneo
  • Repository
  • 29 Watchers
  • 69 Stars
  • 15,501 Installations
  • PHP
  • 4 Dependents
  • 0 Suggesters
  • 18 Forks
  • 8 Open issues
  • 12 Versions
  • 6 % Grown

The README.md

Akeneo Spreadsheet Parser

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

The current version of the spreadsheet parser works with csv and xlsx files., (*2)

Travis Build Status Scrutinizer Code Quality, (*3)

Installing the package

From your application root:, (*4)

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

Usage

To extract data from an XLSX spreadsheet, use the following code:, (*5)

    use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

    $workbook = SpreadsheetParser::open('myfile.xlsx');

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

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

By using the CSV parser options, you can specify the format of your CSV file :, (*6)

    use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

    $workbook = SpreadsheetParser::open('myfile.csv');

    $iterator = $workbook->createRowIterator(
        0,
        [
            'encoding'  => 'UTF-8',
            'length'    => null,
            'delimiter' => ',',
            'enclosure' => '"',
            'escape'    => '\\'
        ]
    );


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

Running the tests

To run unit tests, use phpspec:, (*7)

    $ php bin/phpspec run

To run integration tests, use phpunit:, (*8)

    $ phpunit

The Versions

29/07 2016

dev-master

9999999-dev http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel
by JM Leroux

parser excel spreadsheet xlsx akeneo reader

29/07 2016

v1.2.1

1.2.1.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel
by JM Leroux

parser excel spreadsheet xlsx akeneo reader

25/03 2016

v1.2.0

1.2.0.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel
by JM Leroux

parser excel spreadsheet xlsx akeneo reader

05/10 2015

v1.1.7

1.1.7.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

12/08 2015

v1.1.6

1.1.6.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

02/09 2014

v1.1.5

1.1.5.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

08/08 2014

v1.1.4

1.1.4.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

25/06 2014

v1.1.3

1.1.3.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

18/06 2014

v1.1.2

1.1.2.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

15/06 2014

v1.1.1

1.1.1.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

09/06 2014

v1.1.0

1.1.0.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Requires

 

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader

24/05 2014

v1.0.0

1.0.0.0 http://akeneo.com

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

  Sources   Download

OSL-3.0

The Development Requires

by Antoine Guigan
by Matthieu Viel

parser excel spreadsheet xlsx akeneo reader