MNB PHPExcelDeveloper Guide
v2.0.5
Documentation versions v2.0.5Current v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
Database XLSX integration

Database XLSX Integration

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

Updated

LevelIntermediateReading time7 minPackagemnb/mnb-phpexcel
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:^2.0

Understand its declared graph#

PackageResponsibility
mnb/mnb-phpexcelShared reader contracts, sessions, options, progress, and row normalization.
mnb/mnb-phpexcelNative low-memory XLSX worksheet streaming.
mnb/mnb-phpexcelValidation, mapping, prepared PDO batches, manifests, and failed rows.
mnb/mnb-phpexcelCoordinates those modules through LargeExcelDatabaseImportEngine.

Use Database alone when possible#

Install only mnb/mnb-phpexcel:^2.0 when your application already has iterable rows, imports CSV/JSON/XML/XLS through separate modules, or does not need direct XLSX chunk orchestration.