Skip to content
PHP 8.1+ Open source Developer documentation
Tools Packagist
Docs v2.0.6
Documentation versions v2.0.6Current v2.0.5Maintenance v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
MNB PHPExcelDeveloper Guide
AI

Reference

API Overview

A practical map of the main public classes, returned objects, and common entry points.

Level
All levels
Reading time
9 min
Package
mnb/mnb-phpexcel
Updated
API orientation

Start with the object that owns the job.

The public surface is intentionally layered. Most projects begin with the application facade, then move into a read session, workbook builder, focused format API, or specialist engine only when the workflow needs it.

Most application codeMnb\PHPExcel\MnbExcel

Use the high-level facade for common read, write, import, security, and workflow operations.

Reading workbooksMnb\PHPExcel\Reader\ReadSession

Work with sheets, rows, cells, metadata, chunks, and terminal read operations.

Shared read policyMnb\PHPExcel\Reader\Options\ReaderOptions

Keep immutable reader defaults for ranges, projection, formulas, errors, passwords, and progress.

Building workbooksMnb\PHPExcel\Core\WorkbookBuilder

Compose worksheets, formatting, charts, pivots, protection, encryption, and output.

01 · API surface

Application & core

Start here for most application workflows and the core objects returned by high-level entry points.

Mnb\PHPExcel\MnbExcelApplication

High-level facade for reading, writing, domain imports, security, queues, HTTP, email, and scheduling.

View source →
Mnb\PHPExcel\Reader\Options\ReaderOptionsCore

Immutable configuration for ranges, projection, mode, passwords, formulas, errors, and progress.

View source →
Mnb\PHPExcel\Reader\ReadSessionCore

Unified strict and optional sheet selection, active-sheet discovery, normal/streaming reads, empty checks, row counts, cells, metadata, chunks, validation, and conversions.

View source →
Mnb\PHPExcel\Core\WorkbookBuilderApplication

Fluent workbook composition, formatting, images, charts, pivots, protection, encryption, and saving.

View source →
02 · API surface

Format-specific & inspection

Use focused format APIs or lightweight inspection when the job is narrower than the application facade.

Mnb\PHPExcel\Format\XlsxXLSX

Focused static entry point for XLSX reads, cells, ranges, images, encryption, templates, and writing.

View source →
Mnb\PHPExcel\Format\XlsXLS

Focused static entry point for the independent native BIFF8/OLE reader and writer.

View source →
Mnb\PHPExcel\Reader\XlsxInspectorXLSX

Lightweight XLSX package, sheet, dimension, security, and integrity inspection without converting worksheet rows to arrays.

View source →
03 · API surface

Large files & database

Choose these surfaces when the workload is intentionally streaming, chunked, resumable, or database-oriented.

Mnb\PHPExcel\Large\LargeXlsxReadSessionXLSX

Large XLSX chunk processing, projection, transformations, guards, passwords, and progress.

View source →
Mnb\PHPExcel\Large\LargeXlsxWriteSessionXLSX

Streaming XLSX/CSV ZIP output from iterables and SQL cursors.

View source →
Mnb\PHPExcel\Import\SqlImporterDatabase

Format-neutral prepared PDO batch insertion, mapping, duplicate strategies, and dry-run planning.

View source →
Mnb\PHPExcel\Large\LargeExcelDatabaseImportEngineDatabase XLSX

Optional large XLSX-to-PDO orchestration with chunks, manifests, resume, validation, and failed rows.

View source →
04 · API surface

Developer support

Development-only support for clearer uncaught MNB exception output while debugging integrations.

Mnb\PHPExcel\Support\MnbExcelErrorHandlerCore

Opt-in clean rendering for uncaught MNB exceptions during CLI, browser, and JSON development workflows.

View source →