MNB PHPExcelDeveloper Guide
v2.0.5
ODS module

Reading ODS Workbooks

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

Updated

LevelIntermediateReading time7 minPackagemnb/mnb-phpexcel
Ods::read()sheetNames()projectColumns()withFormulaMode()

What you will learn

  • List worksheets and choose one by index or name.
  • Project source columns and trim trailing empty cells.
  • Return formulas, cached values, or both.

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();