jhesyong/simple-excel-parser

A simple excel parser based on phpoffice/phpexcel

Simple Excel Parser

A simple excel parser that parses each row to an associative array., _(*1)

When to use this?

• Your excel file has the header at the first row, and data at the rest rows.
• You want to map the header titles to database keys.
• You want to map the data values to database enums.

Example

You want to parse an excel file with the following format., _(*2)

And you want to map the header titles to database table fields, and map genders to 'm' or 'f'., _(*3)

$parser = new Jhesyong\Excel\Parser;

// Map 'Name' to 'name', 'Age' to 'age', and 'Gender' to 'gender'.
$parser->addHeader('Name', 'name');
$parser->addHeader('Age', 'age');

// Map the values: 'm' is for 'Male', and 'f' is for 'Female'
$parser->addHeader('Gender', 'gender')->withOptions(['m' => 'Male', 'f' => 'Female']);

// You can use a regular expression and pass a callback to map multiple header titles.
// In this case, 'Phone 1' will be mapped to 'phone_1'
$parser->addHeader('/^Phone \d+$/', function($title)
{
    return str_replace(' ', '_', strtolower($title));
});

// Load the file and start to parse. Pass a callback function
// and it will be called for each row.
$parser->loadFile('filename.xlsx')->parse(function($data)
{
    // Data will be an associative array.
    var_dump($data);
});

FAQ

I have multiple titles of the same text, but I want to map them to different database table fields.

You can add headers with the same title but different field names in the desired order., _(*4)

// The first 'Phone' will be mapped to 'phone_1',
// and the second 'Phone' will be mapped to 'phone_2'
$parser->addHeader('Phone', 'phone_1');
$parser->addHeader('Phone', 'phone_2');

I just want to use the title as the field name

You can omit the second argument., _(*5)

// 'Phone' will be mapped to 'Phone'
$parser->addHeader('Phone');

I want to pre-define the header mapping and the options.

You can extend the Parser and write your rules in the constructor., _(*6)