ODS Module
Read OpenDocument Spreadsheet files with a native forward-only reader, sheet selection, projection, formulas, and dates.
Updated
Ods::read()sheetNames()rows()What you will learn
- Install the native ODS reader module.
- 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:^2.0ZIP and XMLReader support are required by the current native ODS reader implementation.
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 module |
Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.
Open an issue