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

Standalone ODS capabilities

Forward-only OpenDocument Spreadsheet reading features.

The ODS library is a focused native reader for OpenDocument Spreadsheet files. It supports worksheets, repeated rows and cells, formulas, dates, projection, and controlled streaming.

Package
1
ODS
Capabilities
7
Documented for this library
Feature groups
2
Package-specific responsibilities

Updated

LevelAll levelsReading time4 minPackagemnb/mnb-phpexcel-ods

What you will learn

  • Understand the standalone ODS reader feature set.
  • See the current reader-only and presentation boundaries.
  • Open the ODS reading or streaming-options guide.

What this library includes

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

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

Package quick start

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

ods-features.php
<?php

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

use Mnb\PHPExcel\Format\Ods;

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

Supported capabilities

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

7 of 7 features

Reading6 capabilities
FeatureWhat it doesTypical useSupportGuide
Worksheet discovery and selectionList and select named ODS tables.Multi-sheet LibreOffice filesSupportedOpen guide
Forward-only row iterationStream table rows without materializing the entire document.Large ODS importsSupportedOpen guide
Repeated rows and cellsExpand ODS repetition attributes under configured safety limits.Compact OpenDocument filesSupportedOpen guide
Header normalization and projectionCreate associative records and retain only required columns.Data importsSupportedOpen guide
Formulas and cached valuesReturn formula text, cached values, or both according to reader options.Analytical sheetsSupportedOpen guide
Dates and typed valuesInterpret OpenDocument scalar types and date representations.Business recordsSupportedOpen guide
Security1 capabilities
FeatureWhat it doesTypical useSupportGuide
ODS ZIP package validationValidate required package entries and constrain repeated structures and source size.Production uploadsSupportedOpen guide

Feature boundaries

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

CapabilityStatusWhat to use instead
ODS writingNot supported: The current package is reader-only.The current package is reader-only.
Rich presentation extractionPartially supported: The reader focuses on normalized data rather than full style/media fidelity.The reader focuses on normalized data rather than full style/media fidelity.
Excel password encryptionNot supported: ODS package handling does not implement XLSX Office encryption.ODS package handling does not implement XLSX Office encryption.