PHPackages                             disalvo/spreadsheet-parser - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. disalvo/spreadsheet-parser

ActiveLibrary[PDF & Document Generation](/categories/documents)

disalvo/spreadsheet-parser
==========================

Enhanced Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

v1.2.3(8y ago)2372OSL-3.0PHPPHP >=5.4.0

Since May 24Pushed 8y ago1 watchersCompare

[ Source](https://github.com/disalvo/spreadsheet-parser)[ Packagist](https://packagist.org/packages/disalvo/spreadsheet-parser)[ Docs](http://akeneo.com)[ RSS](/packages/disalvo-spreadsheet-parser/feed)WikiDiscussions master Synced 2d ago

READMEChangelog (1)Dependencies (2)Versions (15)Used By (0)

Akeneo Spreadsheet Parser
=========================

[](#akeneo-spreadsheet-parser)

This component is designed to extract data from spreadsheets, while being easy on resources, even for large files.

The current version of the spreadsheet parser works with csv and xlsx files.

[![Travis Build Status](https://camo.githubusercontent.com/8c8edbccd5122ab68d5282685bc170c21ec15a04fb710383518f44aa894d9c52/68747470733a2f2f7472617669732d63692e6f72672f616b656e656f2d6c6162732f73707265616473686565742d7061727365722e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/akeneo-labs/spreadsheet-parser)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/3ab32db6b8725e69c41c493a5f736e1d0cebdcbd2127db10edca228a03555226/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f616b656e656f2d6c6162732f73707265616473686565742d7061727365722f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/akeneo-labs/spreadsheet-parser/?branch=master)

Installing the package
----------------------

[](#installing-the-package)

From your application root:

```
    $ php composer.phar require --prefer-dist "disalvo/spreadsheet-parser"
```

Usage
-----

[](#usage)

To extract data from an XLSX spreadsheet, use the following code:

```
    use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

    $workbook = SpreadsheetParser::open('myfile.xlsx');

    $myWorksheetIndex = $workbook->getWorksheetIndex('myworksheet');

    foreach ($workbook->createRowIterator($myWorksheetIndex) as $rowIndex => $values) {
        var_dump($rowIndex, $values);
    }
```

By using the CSV parser options, you can specify the format of your CSV file :

```
    use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

    $workbook = SpreadsheetParser::open('myfile.csv');

    $iterator = $workbook->createRowIterator(
        0,
        [
            'encoding'  => 'UTF-8',
            'length'    => null,
            'delimiter' => ',',
            'enclosure' => '"',
            'escape'    => '\\'
        ]
    );

    foreach ($workbook->createRowIterator(0) as $rowIndex => $values) {
        var_dump($rowIndex, $values);
    }
```

Running the tests
-----------------

[](#running-the-tests)

To run unit tests, use phpspec:

```
    $ php bin/phpspec run
```

To run integration tests, use phpunit:

```
    $ phpunit
```

###  Health Score

32

—

LowBetter than 72% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity15

Limited adoption so far

Community15

Small or concentrated contributor base

Maturity66

Established project with proven stability

 Bus Factor2

2 contributors hold 50%+ of commits

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~102 days

Recently: every ~181 days

Total

13

Last Release

3151d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/99a445a096c08e6f25e0bd969fb4b9531f98bc2f721596fb70735516c574ea37?d=identicon)[disalvo](/maintainers/disalvo)

---

Top Contributors

[![jmleroux](https://avatars.githubusercontent.com/u/1516770?v=4)](https://github.com/jmleroux "jmleroux (15 commits)")[![stof](https://avatars.githubusercontent.com/u/439401?v=4)](https://github.com/stof "stof (11 commits)")[![fitn](https://avatars.githubusercontent.com/u/2131005?v=4)](https://github.com/fitn "fitn (10 commits)")[![disalvo](https://avatars.githubusercontent.com/u/303916?v=4)](https://github.com/disalvo "disalvo (4 commits)")[![damien-carcel](https://avatars.githubusercontent.com/u/5039018?v=4)](https://github.com/damien-carcel "damien-carcel (3 commits)")[![MarieMinasyan](https://avatars.githubusercontent.com/u/1398717?v=4)](https://github.com/MarieMinasyan "MarieMinasyan (2 commits)")[![xakepsoft](https://avatars.githubusercontent.com/u/14543154?v=4)](https://github.com/xakepsoft "xakepsoft (1 commits)")[![harikt](https://avatars.githubusercontent.com/u/120454?v=4)](https://github.com/harikt "harikt (1 commits)")[![bocharsky-bw](https://avatars.githubusercontent.com/u/3317635?v=4)](https://github.com/bocharsky-bw "bocharsky-bw (1 commits)")

---

Tags

parserexcelxlsxreaderspreadsheetakeneodisalvo

### Embed Badge

![Health badge](/badges/disalvo-spreadsheet-parser/health.svg)

```
[![Health](https://phpackages.com/badges/disalvo-spreadsheet-parser/health.svg)](https://phpackages.com/packages/disalvo-spreadsheet-parser)
```

###  Alternatives

[phpoffice/phpspreadsheet

PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine

13.9k293.5M1.3k](/packages/phpoffice-phpspreadsheet)[akeneo-labs/spreadsheet-parser

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

147598.3k6](/packages/akeneo-labs-spreadsheet-parser)[shuchkin/simplexlsx

Parse and retrieve data from Excel XLSx files. MS Excel 2007 workbooks PHP reader.

1.8k3.8M21](/packages/shuchkin-simplexlsx)[openspout/openspout

PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

1.1k57.6M131](/packages/openspout-openspout)[avadim/fast-excel-reader

Lightweight and very fast XLSX Excel Spreadsheet Reader in PHP

104608.4k6](/packages/avadim-fast-excel-reader)[nuovo/spreadsheet-reader

Spreadsheet reader library for Excel, OpenOffice and structured text files

669863.2k8](/packages/nuovo-spreadsheet-reader)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)