MNB PHPExcelDeveloper Guide
Getting started

Main Package and Feature Areas

Install the main MNB PHPExcel package and understand which feature area owns each spreadsheet task.

Updated

LevelBeginnerReading time6 minPackagemnb/mnb-phpexcel

What you will learn

  • Understand the feature areas included in the main package.
  • Use one Composer installation for all documented APIs.
  • Use the MnbExcel facade as the default entry point.

Use one package for the entire spreadsheet platform.

The main package is the default choice for documentation examples and applications that work across multiple formats or workflows.

Best starting point

MNB PHPExcel main package

Install once, then choose the facade, fluent session, builder, or specialized format class that best matches the task.

  • XLSX, XLS, CSV, JSON, XML, and ODS
  • Row streaming and bounded-memory processing
  • Workbook reports, formulas, charts, and styling
  • PDO imports, validation, and failed-row output
  • Upload security and AES-256 XLSX encryption
  • Queues, HTTP, email, and scheduled workflows
Composer
composer require mnb/mnb-phpexcel:^2.0
Default entry pointuse Mnb\PHPExcel\MnbExcel;
Included libraries
XLSXXLSCSVJSONXMLODSDatabaseDB XLSX

Install only the library your application needs.

Individual packages are useful for narrow services, smaller dependency graphs, and format-specific applications.

XExcel 2007+

XLSX

Native XLSX reading, writing, streaming, formulas, styles, charts, and AES-256 security.

mnb/mnb-phpexcel-xlsx:^2.0
Open XLSX guide
XExcel 97–2003

XLS

Independent BIFF8 and OLE/CFB reading and writing for legacy Excel workbooks.

mnb/mnb-phpexcel-xls:^2.0
Open XLS guide
CCSV + TSV

CSV

Low-memory delimited-file streaming, dialect detection, encoding conversion, and safe output.

mnb/mnb-phpexcel-csv:^2.0
Open CSV guide
JJSON + NDJSON

JSON

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

mnb/mnb-phpexcel-json:^2.0
Open JSON guide
XSecure XML

XML

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

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

ODS

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

mnb/mnb-phpexcel-ods:^2.0
Open ODS guide
DPDO imports

Database

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

mnb/mnb-phpexcel-database:^2.0
Open Database guide
DXLSX → PDO

Database XLSX

Stream very large XLSX worksheets into PDO with chunks, resume manifests, and failure output.

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

Main package or individual library?

Choose by application boundary, not by file extension alone.

Choose the main package

Multiple spreadsheet tasks

  • Your application reads and writes more than one format.
  • You need reports, imports, large-file tools, or workflow services.
  • You want every documentation example to work without package changes.
  • You prefer one stable facade across the application.
mnb/mnb-phpexcel:^2.0
Choose an individual library

One focused responsibility

  • A service processes only XLSX, CSV, JSON, XML, ODS, or XLS.
  • You are building a small worker or integration with a narrow boundary.
  • You want explicit format ownership in Composer dependencies.
  • You do not need cross-format application workflows.
mnb/mnb-phpexcel-xlsx:^2.0
General applicationMain package
Large XLSX readerXLSX library
Delimited export serviceCSV library
Database import workerDatabase + format library

Pick the entry point that matches the task.

The package controls installation. The entry point controls how your application works with spreadsheet data.

M
Default facade

MnbExcel

Mnb\PHPExcel\MnbExcel

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

R
Fluent reading

ReadSession

Mnb\PHPExcel\ReadSession

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

W
Workbook output

WorkbookBuilder

Mnb\PHPExcel\WorkbookBuilder

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

F
Specialized APIs

Format classes

Mnb\PHPExcel\Format\*

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

Composermnb/mnb-phpexcel
Format enginesXLSX · XLS · CSV · JSON · XML · ODS
Your applicationMnbExcel facade
One documented distribution

Install mnb/mnb-phpexcel to follow every guide. Specialized format classes are already included.

Native spreadsheet engines

MNB PHPExcel 2.x does not require, wrap, suggest, or call PhpSpreadsheet.