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 →
XLSX library

Standalone XLSX capabilities

Native XLSX features for reading, writing, security, and scale.

The XLSX library owns modern Excel workbook processing without requiring the monolithic package. It covers normalized row APIs, rich workbook output, package inspection, encryption, and bounded-memory processing.

Package
1
XLSX
Capabilities
17
Documented for this library
Feature groups
6
Package-specific responsibilities

Updated

LevelAll levelsReading time5 minPackagemnb/mnb-phpexcel-xlsx

What you will learn

  • See which capabilities belong to the standalone XLSX package.
  • Separate XLSX features from monolithic application workflows.
  • Open the package-specific guide for each supported capability.

What this library includes

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

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

Package quick start

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

xlsx-features.php
<?php

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

use Mnb\PHPExcel\Format\Xlsx;

$rows = Xlsx::read('orders.xlsx')
    ->sheet('Orders')
    ->withHeaderRow(1)
    ->projectColumns(['Order ID', 'Total'])
    ->rows();

Xlsx::write($rows, 'orders-copy.xlsx');

Supported capabilities

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

17 of 17 features

Reading5 capabilities
FeatureWhat it doesTypical useSupportGuide
Worksheet discovery and selectionList worksheets, select by name or index, and work with active/default-sheet helpers.Multi-sheet business workbooksSupportedOpen guide
Header rows and associative recordsChoose a 1-based header row and receive normalized associative rows.Imports and APIsSupportedOpen guide
Ranges, row limits, and column projectionRead only the source rows and columns required by the application.Faster targeted processingSupportedOpen guide
Formulas and cached valuesReturn formula text, cached results, or combined formula result objects.Financial and analytical workbooksSupportedOpen guide
Dates and typed scalar valuesNormalize Excel dates, booleans, numbers, strings, and empty values.Reliable domain mappingSupportedOpen guide
Workbook metadata1 capabilities
FeatureWhat it doesTypical useSupportGuide
Styles, comments, hyperlinks, and imagesInspect rich cell details and workbook presentation metadata.Template and document analysisSupportedOpen guide
Inspection1 capabilities
FeatureWhat it doesTypical useSupportGuide
Sheet names, dimensions, and row countsInspect workbook structure and count normalized rows before a full workflow.Upload previews and routingSupportedOpen guide
Writing4 capabilities
FeatureWhat it doesTypical useSupportGuide
Simple row exportWrite arrays or iterables to a valid XLSX workbook through the package facade.Downloads and reportsSupportedOpen guide
Rich workbook data modelCreate multiple sheets with formulas, styles, number formats, merged cells, widths, and row heights.Professional reportsSupportedOpen guide
Validation, conditional formatting, and filtersAdd worksheet validation rules, conditional styles, filters, and freeze panes.Import templates and dashboardsSupportedOpen guide
Comments, hyperlinks, images, charts, and pivotsSerialize richer workbook objects and range-based presentation definitions.Management reportingSupportedOpen guide
Security3 capabilities
FeatureWhat it doesTypical useSupportGuide
Password-to-open encryptionRead and create Standard or Agile encrypted XLSX packages.Confidential workbooksSupportedOpen guide
Workbook and worksheet protectionRestrict workbook structure or worksheet editing separately from file encryption.Controlled templatesSupportedOpen guide
ZIP and package integrity checksValidate paths, compression ratios, package relationships, macros, external links, and malformed input.Production uploadsSupportedOpen guide
Large files3 capabilities
FeatureWhat it doesTypical useSupportGuide
Forward-only streaming readsProcess rows without building the complete workbook in PHP memory.Large importsSupportedOpen guide
Chunking, progress, and row errorsRun bounded batches with progress callbacks and structured failure reporting.Queue workers and ETLSupportedOpen guide
Streaming writerWrite large row iterables with controlled shared-string and temporary-file strategies.Large exportsSupportedOpen guide

Feature boundaries

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

CapabilityStatusWhat to use instead
Legacy .xls filesNot supported: Install mnb/mnb-phpexcel-xls for BIFF8 Excel 97–2003 workbooks.Install mnb/mnb-phpexcel-xls for BIFF8 Excel 97–2003 workbooks.
Database insertion and domain presetsNot supported: Install the Database package; add Database + XLSX for direct large-XLSX-to-PDO orchestration.Install the Database package; add Database + XLSX for direct large-XLSX-to-PDO orchestration.
Application-level multi-format facadeNot supported: Use mnb/mnb-phpexcel when one MnbExcel facade must coordinate several formats and workflows.Use mnb/mnb-phpexcel when one MnbExcel facade must coordinate several formats and workflows.