mnb / mnb-phpexcel-database-xlsx

v2.0.0 2026-07-29 09:29 UTC

Requires

• php: >=8.1
• ext-pdo: *
• mnb/mnb-phpexcel-core: ^2.0
• mnb/mnb-phpexcel-database: ^2.0
• mnb/mnb-phpexcel-xlsx: ^2.0

Conflicts

• mnb/mnb-phpexcel: *

MIT

Published on Packagist.org on 2026-07-29 09:32 UTC

README

Optional integration package for importing very large XLSX worksheets into PDO databases without loading the full worksheet into memory.

MNB PHPExcel Assistant

Generate MNB PHPExcel code using our dedicated ChatGPT assistant:

Open MNB PHPExcel AI Assistant

composer require mnb/mnb-phpexcel-database-xlsx:^2.0

This package intentionally combines three independent modules:

• mnb/mnb-phpexcel-xlsx for native XLSX streaming
• mnb/mnb-phpexcel-database for validation and PDO insertion
• mnb/mnb-phpexcel-core for shared contracts and row processing

Direct API

use Mnb\PHPExcel\Large\LargeExcelDatabaseImportEngine;

$result = (new LargeExcelDatabaseImportEngine())->importToSql(
    __DIR__ . '/data/import.xlsx',
    $pdo,
    'customers',
    [
        'sheet' => 'Customers',
        'with_header' => true,
        'chunk_size' => 1000,
        'batch_size' => 500,
        'resume' => true,
    ]
);

Install mnb/mnb-phpexcel-database alone when XLSX-specific streaming imports are not required.