Skip to content
MNB PHPExcelDeveloper Guide
AI

Composer packages

Choose a package by responsibility.

MNB PHPExcel can be installed as one complete spreadsheet toolkit or as a focused library for a single format or import workflow. Pick the smallest boundary that matches your application.

Updated

LevelAll levelsReading time5 minPackagemnb/mnb-phpexcel

Start with one distribution decision.

The complete package is best for general applications. A focused package is better when a service has one clear format or import responsibility.

Recommended default

Complete package

Use one dependency when the application works across formats, reports, imports, large files, or application workflows.

Composer
composer require mnb/mnb-phpexcel:^2.0
  • Includes all focused format and database libraries.
  • Matches the default package used throughout the documentation.
  • Keeps one stable application-facing API as requirements grow.
Focused dependency

Individual library

Use a smaller package when one service owns a specific format or import boundary and does not need the broader toolkit.

Single file format
XLSX, XLS, CSV, JSON, XML, or ODS
Import-only worker
Database or Database XLSX
Best fit
Small workers, integrations, and isolated services
See focused packages

Install only the capability your service owns.

Each package below has one clear responsibility. Its purpose, Composer command, and corresponding guide stay together for quick scanning.

XLSX

Excel 2007+

Modern Excel files with reading, writing, streaming, formulas, styles, charts, and XLSX security.

mnb/mnb-phpexcel-xlsx:^2.0
Open guide

XLS

Excel 97–2003

Legacy BIFF8 workbooks with independent OLE/CFB reading and writing.

mnb/mnb-phpexcel-xls:^2.0
Open guide

CSV

CSV + TSV

Delimited files with low-memory streaming, dialect detection, encoding conversion, and safe output.

mnb/mnb-phpexcel-csv:^2.0
Open guide

JSON

JSON + NDJSON

JSON arrays, workbook-shaped documents, JSON Lines, NDJSON, and streamed pipelines.

mnb/mnb-phpexcel-json:^2.0
Open guide

XML

Secure XML

Forward-only XML processing with secure parser defaults, schema mapping, and configurable output.

mnb/mnb-phpexcel-xml:^2.0
Open guide

ODS

OpenDocument

OpenDocument Spreadsheet reading with sheets, projection, dates, and formulas.

mnb/mnb-phpexcel-ods:^2.0
Open guide

Database

PDO imports

Format-neutral PDO imports with mapping, validation, batching, presets, and failed-row reports.

mnb/mnb-phpexcel-database:^2.0
Open guide

Database XLSX

XLSX → PDO

Large XLSX-to-PDO imports with streaming, chunks, resume manifests, and failure output.

mnb/mnb-phpexcel-database-xlsx:^2.0
Open guide

Use the API entry point that matches the task.

Composer decides what code is installed. These entry points decide how your application reads, writes, or performs specialized format work.

Default facade

MnbExcel

Mnb\PHPExcel\MnbExcel

Open files, create workbooks, run imports, start large-file jobs, and access application workflows.

Fluent reading

ReadSession

Mnb\PHPExcel\ReadSession

Select worksheets, map headers, project columns, stream rows, count data, and produce arrays.

Workbook output

WorkbookBuilder

Mnb\PHPExcel\WorkbookBuilder

Compose worksheets, apply formatting, add formulas and charts, protect content, and save files.

Specialized APIs

Format classes

Mnb\PHPExcel\Format\*

Use format-specific operations such as XLSX encryption inspection, direct cell access, or native XLS helpers.