MNB PHPExcelDeveloper Guide
AI Assistant
v2.0.6
Documentation versions v2.0.6Current v2.0.5Maintenance v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
DB + XLSX library

Standalone DB + XLSX Library

Install the optional bridge that combines native XLSX streaming with independent PDO validation and insertion workflows.

Updated

LevelIntermediateReading time7 minPackagemnb/mnb-phpexcel-database-xlsx
LargeExcelDatabaseImportEngine::importToSql()importWorkbookToSql()

What you will learn

  • Install the integration only when direct large-XLSX-to-PDO streaming is needed.
  • Understand the three independent packages connected by the bridge.
  • Keep normal database workflows free from an XLSX dependency.

Install the bridge#

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

This bridge installs Core, Database, and XLSX transitively. Install it instead of the mono library; the individual packages conflict with mnb/mnb-phpexcel.

Understand its declared graph#

PackageResponsibility
mnb/mnb-phpexcel-coreShared reader contracts, sessions, options, progress, and row normalization.
mnb/mnb-phpexcel-xlsxNative low-memory XLSX worksheet streaming.
mnb/mnb-phpexcel-databaseValidation, mapping, prepared PDO batches, manifests, and failed rows.
mnb/mnb-phpexcel-database-xlsxCoordinates those libraries through LargeExcelDatabaseImportEngine.

Use Database alone when possible#

Install only mnb/mnb-phpexcel-database:^2.0 when your application already has iterable rows or does not need direct XLSX chunk orchestration. Add a focused format library only when Database must open that source format itself.