Leading PHP Library for ODS, XLSX & CSV Files

How to Install Spout PHP Library

Spout needs PHP version 7.1 or higher. Once prerequisite is met, install Spout from Composer.

$ composer require box/spout

PHP Library to Read & Write ODS, XLSX & CSV

Spout enables software developers to create spreadsheet files from scratch in 3 popular formats. While reading, Spout guesses the spreadsheet reader type based on the file extension. In case the extension is not standard, a specific reader can be created directly.

Read ODS via PHP

1. Create a reader for ODS file format
2. Pass the ODS file path to load method to read it
3. Iterate over ODS worksheets via getSheetIterator()
4. Iterate over worksheet rows via getRowIterator()
5. Get cells of a ODS row to read or write

use Box\Spout\Reader\Common\Creator\ReaderEntityFactory;

$reader = ReaderEntityFactory::createODSReader('/path/to/file.ods');

$reader->open($filePath);

foreach ($reader->getSheetIterator() as $sheet) {
  foreach ($sheet->getRowIterator() as $row) {
    // do stuff with the row
    $cells = $row->getCells();
    ...
  }
}

$reader->close();

Add Data to Existing Spreadsheet via PHP

Spout gives the developer the ability to update an existing spreadsheet by adding data to it. It’s a very common practice to add new data to an existing spreadsheet. Spout API does not keep full spreadsheet representation in memory in order to avoid memory issues while working with large spreadsheets. To modify a spreadsheet create a new instance similar to the existing one and add the required data to the new spreadsheet.

Reading Data from a Specific Sheet

Spout API enables PHP developers to access and read data from a specific sheet inside a spreadsheet. Usually, a spreadsheet contains several worksheets. If a user is interested to read data from only one sheet and skip the other sheets. The users just need to know the name and position of the spreadsheet.