ODS · Reading
ODS reading examples.
Package-local, copy-ready examples organized like the classes and methods reference. Open one example at a time, search by method, and jump from the right-side index.
ODS individual library
Reading examples with copy-ready, production-minded PHP.
Every snippet uses mnb/mnb-phpexcel-ods or its declared Core dependency. Each copied snippet includes strict typing, a concise summary, implementation guidance, readable limits, and a safe fixture check.
- 2
- examples
- 8
- documented methods
Ods::read()sheet()withHeaderRow()streaming()rows()<?php
declare(strict_types=1);
/*
Summary:
Select a named ODS table and stream it as associative rows.
Implementation note:
The standalone ODS package is reader-only. Choose a supported writer package when the workflow
also needs output generation.
*/
use Mnb\PHPExcel\Format\Ods;
$rows = Ods::read(__DIR__ . '/inventory.ods')
->sheet('Inventory')
->withHeaderRow(1)
->streaming()
->rows();
foreach ($rows as $row) {
echo $row['SKU'] . PHP_EOL;
}sheetNames()sheetIfExists()activeSheet()rows()<?php
declare(strict_types=1);
/*
Summary:
Discover OpenDocument table names and choose one without assuming workbook order.
Implementation note:
Named selection is resilient when users reorder tables in LibreOffice or another OpenDocument
editor.
*/
use Mnb\PHPExcel\Format\Ods;
$session = Ods::read(__DIR__ . '/planning.ods');
print_r($session->sheetNames());
$rows = ($session->sheetIfExists('Forecast') ?? $session->activeSheet())
->withHeaderRow(1)
->rows();No matching example found.Try a method name, task, or result.
Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.
Open an issue