<?php

declare(strict_types=1);

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

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

$path = __DIR__ . '/../samples/large-orders.xlsx';

try {
    $session = MnbExcel::read($path)
        ->sheet('Orders')
        ->withHeaderRow(1)
        ->selectColumns(['Order ID', 'Status', 'Amount'])
        ->withOptions(['skip_empty_rows' => true]);

    foreach ($session->chunk(100) as $batchNumber => $batch) {
        printf("Batch %d: %d rows%s", $batchNumber + 1, count($batch), PHP_EOL);
        // Persist or process $batch here.
    }
} catch (MnbExcelException $error) {
    fwrite(STDERR, $error->getMessage() . PHP_EOL);
    exit(1);
}