<?php

declare(strict_types=1);

require __DIR__ . '/../../vendor/autoload.php';

use Mnb\PHPExcel\MnbExcel;
use Mnb\PHPExcel\Support\MnbExcelException;

$path = __DIR__ . '/../samples/customers.xlsx';

try {
    $rows = MnbExcel::read($path)
        ->sheet('Customers')
        ->withHeaderRow(1)
        ->toArray([
            'skip_empty_rows' => true,
            'max_rows' => 5000,
        ]);

    print_r($rows);
} catch (MnbExcelException $error) {
    fwrite(STDERR, $error->getMessage() . PHP_EOL);
    exit(1);
}