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
Standalone JSON package

PHP JSON & NDJSON Library for Streaming Data Workflows

Use the standalone MNB PHPExcel JSON package for JSON arrays, workbook-shaped documents, JSON Lines and NDJSON pipelines that need normalized rows, streaming, stable columns, or API-ready output.

Feature matrix API reference
Composer
composer require mnb/mnb-phpexcel-json:^2.0
Package
mnb/mnb-phpexcel-json
Entry API
Mnb\PHPExcel\Format\Json
Runtime
PHP 8.1+
Format
.json / .jsonl / .ndjson

Choose your JSON workflow#

01
Read JSON rows and workbook documentsStream top-level arrays, select workbook-shaped sheets, control columns, and normalize heterogeneous records.
02
Write JSON for files or APIsSerialize normalized rows or complete workbook payloads with predictable scalar conversion and formatting options.
03
Use NDJSON and structured modesProcess one JSON value per line, stream event-style datasets, and preserve workbook-shaped structures when needed.
04
Review package capabilitiesSee document modes, streaming limits, normalization behavior, and writer options in one focused matrix.

Use the right JSON API#

TaskPrimary APIChoose it when
Read normalized rowsJson::read()You want a package-local session for arrays, NDJSON, workbook-shaped JSON, headers, projection, or streaming.
Write row-oriented JSONJson::write()Normalized application rows should become a JSON file with predictable encoding and formatting.
Read a workbook-shaped objectJsonReader::readWorkbook()You need document-level sheet structure rather than only a row session.
Return JSON as a stringJsonWriter::payloadToString()An API response or application layer needs JSON output without writing a file first.

What the standalone JSON package covers#

Documents

Multiple JSON shapes

  • Top-level arrays of row objects
  • JSON Lines and NDJSON streams
  • Workbook-shaped objects with named sheets
  • Single-object and nested normalization modes
Streaming

Bounded row pipelines

  • Forward processing for top-level arrays
  • One-record-per-line NDJSON iteration
  • Stable column controls for heterogeneous records
  • Per-record and source-size safety limits
Write

API-ready JSON output

  • Row arrays and workbook-shaped payloads
  • Pretty printing and zero-fraction preservation
  • String output for HTTP/API responses
  • Explicit structured modes instead of guessed shapes

Package boundary: this guide uses Mnb\PHPExcel\Format\Json from mnb/mnb-phpexcel-json. Install the focused JSON library or the monolithic mnb/mnb-phpexcel package for a project, not both.