webgriffe/associative-spreadsheet-iterator

Associative Spreadsheet Iterator

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., _(*1)

For example, given a spreadsheet like this:, _(*2)

You can iterate over this and get every row as associative array like this:, _(*3)

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:, _(*4)

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

Usage

Simply inlcude Composer's autoloader and instantiate the iterator passing the file path:, _(*5)

<?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
}