MNB PHPExcelDeveloper Guide
AI Assistant
v2.0.6
Documentation versions v2.0.6Current v2.0.5Maintenance v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
JSON library

Standalone JSON capabilities

JSON, JSON Lines, and NDJSON features for application data pipelines.

The JSON library converts arrays and workbook-shaped payloads through the shared row-session model. It also supports line-delimited streaming and deterministic structured output.

Package
1
JSON
Capabilities
9
Documented for this library
Feature groups
3
Package-specific responsibilities

Updated

LevelAll levelsReading time4 minPackagemnb/mnb-phpexcel-json

What you will learn

  • Compare normal JSON and line-delimited processing.
  • Understand workbook-shaped JSON support and boundaries.
  • Open the matching package-specific implementation guide.

What this library includes

This page is limited to mnb/mnb-phpexcel-json. Features from the monolithic package or another individual library are not mixed into this list.

Installcomposer require mnb/mnb-phpexcel-json:^2.0
Primary APIMnb\PHPExcel\Format\Json
ScopeIndividual libraryFocused dependency and package-local API

Package quick start

The example uses the individual-library API documented by this feature page.

json-features.php
<?php

require __DIR__ . '/vendor/autoload.php';

use Mnb\PHPExcel\Format\Json;

$rows = Json::read('events.ndjson', [
    'streaming_columns' => ['id', 'type', 'created_at'],
])->withHeaderRow(1)->rows();

Json::write($rows, 'events.json');

Supported capabilities

Search the capabilities owned by this package and open the matching package-specific guide.

9 of 9 features

Reading5 capabilities
FeatureWhat it doesTypical useSupportGuide
Top-level array documentsRead arrays of records through normalized row sessions.API payload importsSupportedOpen guide
Workbook-shaped JSONRepresent named logical sheets and select them through sheet APIs.Structured application exportsSupportedOpen guide
JSON Lines and NDJSON streamingProcess one object per line with record-size and schema controls.Logs and event feedsSupportedOpen guide
Header and column normalizationPin deterministic columns, handle extra keys, and project fields.Stable ingestion schemasSupportedOpen guide
Typed scalar preservationKeep JSON numbers, booleans, nulls, strings, arrays, and objects according to options.Application data exchangeSupportedOpen guide
Writing3 capabilities
FeatureWhat it doesTypical useSupportGuide
Array and object outputWrite normalized rows to formatted or compact JSON.REST and file integrationsSupportedOpen guide
Workbook-shaped outputSerialize multiple logical sheets through the workbook writer.Multi-section data packagesSupportedOpen guide
JSONL and NDJSON outputEmit records incrementally for streaming consumers.Queues and analytics pipelinesSupportedOpen guide
Scale1 capabilities
FeatureWhat it doesTypical useSupportGuide
Per-record size limitsReject oversized line-delimited records before excessive memory use.Untrusted feedsSupportedOpen guide

Feature boundaries

These limits prevent individual-library documentation from being confused with the complete monolithic package.

CapabilityStatusWhat to use instead
Spreadsheet presentationNot supported: JSON does not carry Excel styles, images, charts, or worksheet protection.JSON does not carry Excel styles, images, charts, or worksheet protection.
Formula calculationNot supported: Formula semantics are not evaluated by the JSON package.Formula semantics are not evaluated by the JSON package.
Database persistenceNot supported: Combine with the Database package when rows must be validated and inserted through PDO.Combine with the Database package when rows must be validated and inserted through PDO.