heyaender/excelintar-reader

Reader for Excelintar

v1.0.0 2024-01-16 18:28 UTC

Requires

• php: >=7.4
• ext-ctype: *
• ext-intl: *
• ext-mbstring: *
• ext-xmlreader: *
• ext-zip: *
• heyaender/excelintar-helper: *

Requires (Dev)

• phpunit/phpunit: ^9.0

MIT

README

Documentation Excelintar Reader (Import Excel)

How to install

composer require heyaender/excelintar-reader

How to use

$sheet = $excel->getSheet('Articles');
$sheet->setReadArea('B5');
foreach ($sheet->nextRow() as $rowNum => $rowData) {
    $user = User::create([
        'name' => $rowData['B'],
        'birthday' => new \Carbon($rowData['C']),
        'password' => bcrypt($rowData['D']),
    ]);
    Article::create([
        'user_id' => $user->id,
        'title' => $rowData['E'],
        'date' => new \Carbon($rowData['F']),
        'public' => $rowData['G'] === 'yes',
    ]);
}

Example Excel to Import