PHPackages                             elton182/spreadsheet - 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 &amp; Document Generation](/categories/documents)
4. /
5. elton182/spreadsheet

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

elton182/spreadsheet
====================

Spreadsheet reader library for Excel, OpenOffice and structured text files, compatible with cakephp3

0.5.11(11y ago)053MITPHPPHP &gt;= 5.3.0

Since Sep 4Pushed 10y ago3 watchersCompare

[ Source](https://github.com/elton182/spreadsheet-reader)[ Packagist](https://packagist.org/packages/elton182/spreadsheet)[ Docs](https://github.com/nuovo/spreadsheet-reader)[ RSS](/packages/elton182-spreadsheet/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependenciesVersions (3)Used By (0)

This is a fork from (). I made this fork so i could make it compatible with cakephp3 and psr-4.

**spreadsheet-reader** is a PHP spreadsheet reader that differs from others in that the main goal for it was efficient data extraction that could handle large (as in really large) files. So far it may not definitely be CPU, time or I/O-efficient but at least it won't run out of memory (except maybe for XLS files).

So far XLSX, ODS and text/CSV file parsing should be memory-efficient. XLS file parsing is done with php-excel-reader from  which, sadly, has memory issues with bigger spreadsheets, as it reads the data all at once and keeps it all in memory.

### Requirements:

[](#requirements)

- PHP 5.3.0 or newer
- PHP must have Zip file support (see )

### Usage on Cakephp Controller:

[](#usage-on-cakephp-controller)

```

```

### Usage:

[](#usage)

All data is read from the file sequentially, with each row being returned as a numeric array. This is about the easiest way to read a file:

```

```

However, now also multiple sheet reading is supported for file formats where it is possible. (In case of CSV, it is handled as if it only has one sheet.)

You can retrieve information about sheets contained in the file by calling the `Sheets()` method which returns an array with sheet indexes as keys and sheet names as values. Then you can change the sheet that's currently being read by passing that index to the `ChangeSheet($Index)` method.

Example:

```

```

If a sheet is changed to the same that is currently open, the position in the file still reverts to the beginning, so as to conform to the same behavior as when changed to a different sheet.

### Testing

[](#testing)

From the command line:

```
php test.php path-to-spreadsheet.xls

```

In the browser:

```
http://path-to-library/test.php?File=/path/to/spreadsheet.xls

```

### Licensing

[](#licensing)

All of the code in this library is licensed under the MIT license as included in the LICENSE file, however, for now the library relies on php-excel-reader library for XLS file parsing which is licensed under the PHP license.

###  Health Score

24

—

LowBetter than 32% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity49

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 81.4% of commits — single point of failure

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

Unknown

Total

1

Last Release

4033d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/8fab60ae29bcd87b0a2a7c9eacc159c4b5abcac9e88a0753e5c9222bd8a99343?d=identicon)[elton182](/maintainers/elton182)

---

Top Contributors

[![pilsetnieks](https://avatars.githubusercontent.com/u/776876?v=4)](https://github.com/pilsetnieks "pilsetnieks (79 commits)")[![elton182](https://avatars.githubusercontent.com/u/8716770?v=4)](https://github.com/elton182 "elton182 (17 commits)")[![matej116](https://avatars.githubusercontent.com/u/2247129?v=4)](https://github.com/matej116 "matej116 (1 commits)")

---

Tags

excelxlsxlsxcsvspreadsheetodsOpenOffice

### Embed Badge

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

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

###  Alternatives

[phpoffice/phpspreadsheet

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

13.9k293.5M1.3k](/packages/phpoffice-phpspreadsheet)[nuovo/spreadsheet-reader

Spreadsheet reader library for Excel, OpenOffice and structured text files

669863.2k8](/packages/nuovo-spreadsheet-reader)[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)[dcat/easy-excel

使用简单实用的语义化接口快速读写Excel文件

155373.4k24](/packages/dcat-easy-excel)[jgrygierek/batch-entity-import-bundle

Importing entities with preview and edit features for Symfony.

101.1M1](/packages/jgrygierek-batch-entity-import-bundle)[jgrygierek/sonata-batch-entity-import-bundle

Importing entities with preview and edit features for Sonata Admin.

10951.2k](/packages/jgrygierek-sonata-batch-entity-import-bundle)

PHPackages © 2026

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