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 ODS package

PHP ODS Library for Reading OpenDocument Spreadsheets

Use the standalone MNB PHPExcel ODS package when your application needs native reading of OpenDocument Spreadsheet .ods files with sheet selection, projection, formulas, dates, typed values, and forward-only processing.

Feature matrix API reference
Composer
composer require mnb/mnb-phpexcel-ods:^2.0
Package
mnb/mnb-phpexcel-ods
Entry API
Mnb\PHPExcel\Format\Ods
Runtime
PHP 8.1+
Format
.ods · OpenDocument Spreadsheet

Choose your ODS workflow#

01
Read OpenDocument spreadsheetsSelect sheets, normalize headers, read formulas and typed values, and iterate rows from LibreOffice or other ODS producers.
02
Tune streaming and reader optionsProject columns, slice rows, control repeated ODS cells, and choose the native or portable forward-reading path.
03
Check current package scopeReview sheet, formula, date, projection, streaming, and compatibility support before integration.
04
Open the package API referenceBrowse the package-local ODS facade, reader classes, options, and public methods.

Use the right ODS API#

TaskPrimary APIChoose it when
Read normalized rowsOds::read()You need a package-local session for sheet selection, headers, projection, formulas, dates, or row iteration.
List available worksheetssheetNames()You need workbook structure before deciding which ODS sheet to process.
Stream a selected sheetstreaming()->rows()Large or repeated-row ODS input should be processed forward-only with bounded application memory.
Project only needed columnsprojectColumns()The source is wide and your application only owns a subset of fields.

What the standalone ODS package covers#

Read

OpenDocument workbook data

  • Named sheets and normalized rows
  • Header rows and source row ranges
  • Dates, typed scalar values and formula data
  • Repeated ODS row/cell expansion
Stream

Focused input processing

  • Column projection and row slicing
  • Forward XML processing for worksheet content
  • Native ext-zip/ext-xmlreader fast paths
  • Portable Core fallbacks where supported
Scope

Read-only in this package

  • Current package focuses on ODS input
  • ODS writing is not exposed here
  • Use XLSX/CSV packages when output is required
  • Keep application upload limits around archive parsing

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