webgriffe/associative-spreadsheet-iterator

1.6.1 2015-11-12 14:40 UTC

Requires

• phpoffice/phpexcel: @stable

Requires (Dev)

• mikey179/vfsstream: @stable

MIT

• Webgriffe Srl

README

This PHP library allows you to iterate over a spreadsheet in an associative way. Every iterated row is indexed by column name. All formats supported by phpoffice/phpexcel are supported.

For example, given a spreadsheet like this:

Name	Description	Price	Stock
RaspberryPi	Raspberry PI Modell B, 512 MB	37.05	12
SanDisk Ultra SDHC	SanDisk Ultra SDHC 8 GB 30 MB/s Classe 10	6.92	54

You can iterate over this and get every row as associative array like this:

array(
    array(
        'Name' => 'RaspberryPi',
        'Description' => 'Raspberry PI Modell B, 512 MB',
        'Price' => 37.05,
        'Stock' => 12,
    ),
    array(
        'Name' => 'SanDisk Ultra SDHC',
        'Description' => 'SanDisk Ultra SDHC 8 GB 30 MB/s Classe 10',
        'Price' => 6.92,
        'Stock' => 54,
    ),
),

Installation

You can install this library with Composer:

$ composer require webgriffe/associative-spreadsheet-iterator @stable

Usage

Simply inlcude Composer's autoloader and instantiate the iterator passing the file path:

<?php

require 'vendor/autoload.php'

$file = '/path/to/spreadsheet.xlsx';
$spreadsheetIterator = new Webgriffe\AssociativeSpreadsheetIterator\Iterator($file);

foreach ($iterator as $row) {
	// $row is an associative array indexed by column name
}