ODS library

Standalone ODS Library

Read OpenDocument Spreadsheet files with a native forward-only reader, sheet selection, projection, formulas, and dates.

Updated August 1, 2026

LevelAll levelsReading time6 minPackagemnb/mnb-phpexcel-ods

Ods::read()sheetNames()rows()

What you will learn

Install the standalone native ODS reader library.
Select sheets and stream repeated ODS rows and cells safely.
Understand that this package is read-only in the current release.

Install ODS support#

composer require mnb/mnb-phpexcel-ods:^2.0

The package requires ext-libxml and ext-zlib. Native ext-zip and ext-xmlreader are recommended for the fastest streaming path; Core provides portable fallbacks.

Read a worksheet#

use Mnb\PHPExcel\Format\Ods;

$rows = Ods::read('inventory.ods')
    ->sheet('Inventory')
    ->withHeaderRow(1)
    ->streaming()
    ->rows();

Current scope#

Capability	Status
Read sheets and rows	Supported
Column projection and row slicing	Supported
Formulas and cached values	Supported
Dates and typed scalar values	Supported
Write ODS	Not in this library

Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.

Open an issue