Large XLSX-to-PDO streaming and resume features.

The Database + XLSX bridge combines the XLSX streaming reader with Database validation and prepared PDO persistence. It is intended for direct, bounded-memory import of very large worksheets.

Package: 1
Capabilities: 10
Feature groups: 6

Updated August 1, 2026

LevelAll levelsReading time5 minPackagemnb/mnb-phpexcel-database-xlsx

What you will learn

See what the XLSX-to-PDO bridge adds.
Distinguish it from the generic Database and XLSX packages.
Open the large-import or resume guide for implementation details.

What this library includes

This page is limited to mnb/mnb-phpexcel-database-xlsx. Features from the monolithic package or another individual library are not mixed into this list.

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

Primary APIMnb\PHPExcel\Large\LargeExcelDatabaseImportEngine

ScopeIndividual libraryFocused dependency and package-local API

Package linksGitHub repository ↗Packagist package ↗

Package quick start

The example uses the individual-library API documented by this feature page.

<?php

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

use Mnb\PHPExcel\Large\LargeExcelDatabaseImportEngine;

$engine = new LargeExcelDatabaseImportEngine($pdo);
$result = $engine->import('products.xlsx', 'products', [
    'sheet' => 'Products',
    'header_row' => 1,
    'chunk_size' => 2000,
    'batch_size' => 500,
    'resume' => true,
]);

Supported capabilities

Search the capabilities owned by this package and open the matching package-specific guide.

XLSX source2 capabilities

Feature	What it does	Typical use	Support	Guide
Direct worksheet streaming	Open one XLSX worksheet and pass normalized rows directly into the database pipeline.	Very large uploads	Supported	Open guide
Sheet and header selection	Choose the worksheet and 1-based header row used for mapping.	Multi-sheet import files	Supported	Open guide

Scale1 capabilities

Feature	What it does	Typical use	Support	Guide
Independent chunk and batch sizes	Tune XLSX orchestration chunks separately from prepared SQL batches.	Memory and transaction control	Supported	Open guide

Mapping1 capabilities

Feature	What it does	Typical use	Support	Guide
Column projection and target mapping	Read only required source columns and map them to database fields.	Wide worksheets	Supported	Open guide

Validation1 capabilities

Feature	What it does	Typical use	Support	Guide
Database package rule pipeline	Apply normalizers, field rules, cross-field checks, defaults, and transformations.	Production data quality	Supported	Open guide

Duplicates1 capabilities

Feature	What it does	Typical use	Support	Guide
Configurable duplicate handling	Insert, update, skip, or fail according to unique keys.	Synchronization jobs	Supported	Open guide

Operations4 capabilities

Feature	What it does	Typical use	Support	Guide
Progress callbacks	Report worksheet and persistence progress to queues, logs, or user interfaces.	Long-running imports	Supported	Open guide
Persistent resume manifests	Checkpoint import state and continue after interruption.	Resilient workers	Supported	Open guide
Failed-row reporting	Preserve physical worksheet row numbers and validation details.	User correction workflows	Supported	Open guide
Idempotent replay design	Coordinate unique keys, checkpoints, and transactions for safe retries.	Queue and cron processing	Supported	Open guide

Feature boundaries

These limits prevent individual-library documentation from being confused with the complete monolithic package.

Capability	Status	What to use instead
General CSV, JSON, XML, ODS, or XLS import	Not supported: Use Database with the relevant format library.	Use Database with the relevant format library.
Rich XLSX report generation	Not supported: This bridge imports rows; XLSX writing belongs to mnb/mnb-phpexcel-xlsx.	This bridge imports rows; XLSX writing belongs to mnb/mnb-phpexcel-xlsx.
Database-independent XLSX processing	Not supported: Use the XLSX library directly when PDO persistence is not required.	Use the XLSX library directly when PDO persistence is not required.

Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.

Open an issue