webgriffe/associative-spreadsheet-iterator

1.6.1 2015-11-12 14:40 UTC

This package is auto-updated.

Last update: 2022-05-07 15:59:33 UTC


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
}