atomatis/simple-data-table-reader

For easily parse basic data table files (xlsx, csv, ...).

1.0.9 2021-04-22 08:13 UTC

Requires

• php: >=7.2.5
• phpoffice/phpspreadsheet: >=1.15
• symfony/yaml: >=4.0

Requires (Dev)

• phpunit/phpunit: ^9.4

GPL-3.0-or-later

• alexandre tomatis

• file
• xlsx
• csv
• reader
• data table

README

POO iterable tools for parse easily any basic data table file (like csv, xlsx, ...).

Installation

With composer

composer require atomatis/simple-data-table-reader

Purpose

Read a simple table_data.xlsx file

Name	ref_id	tel N°
nadege	AR4F9EJ	06 54 65 66 77
gertrude	45345	065 465 656 77

like this

 $reader = SimpleReaderFactory::createTableDataReader('file/table_data.xlsx'/*, ?string $forceExtension*/);
 $reader->getHeader(); // return ['name', 'ref_id', 'tel_n']

 foreach ($reader->getIterator() as $row) {
    // offset 1
    $row->get('name'); // return 'nadege'
    $row->get('ref_id'); // return 'AR4F9EJ'
    $row->get('wrong_ref'); // return null
    $row(); // return ['name' => 'nadege', 'ref_id' => 'AR4F9EJ', 'tel_n' => '06 54 65 66 77']
 }

Other info

Extension available
xlsx
csv