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

ODS library

Reading ODS Workbooks

List and select ODS worksheets, normalize headers, project columns, and choose formula and date representations.

Level
Intermediate
Reading time
7 min
Package
mnb/mnb-phpexcel-ods
Updated
Ods::read()sheetNames()projectColumns()withFormulaMode()

List and select sheets#

PHP
$session = Ods::read('book.ods');
print_r($session->sheetNames());

$rows = $session
    ->sheet('Sales')
    ->withHeaderRow(1)
    ->rows();

Read a projected range#

PHP
$rows = Ods::read('book.ods', [
    'start_row' => 2,
    'end_row' => 100000,
    'columns' => ['A', 'C', 'F'],
    'trim_trailing_empty_cells' => true,
])->sheet('Sales')->rows();

Choose formula and date output#

PHP
$rows = Ods::read('finance.ods', [
    'formula_cells' => 'both',
    'return_datetime' => false,
    'date_format' => 'Y-m-d',
    'datetime_format' => 'Y-m-d H:i:s',
])->sheet('Summary')->rows();