PHPackages shuchkin/simplexls - 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. shuchkin/simplexls ActiveLibrary[PDF & Document Generation](/categories/documents) shuchkin/simplexls ================== Parse and retrieve data from old format Excel XLS files. MS Excel 97 workbooks PHP reader. 1.0.0(1y ago)211683.1k↓45.8%82[6 issues](https://github.com/shuchkin/simplexls/issues)3MITPHPPHP >=5.5 Since Feb 19Pushed 1y ago8 watchersCompare [ Source](https://github.com/shuchkin/simplexls)[ Packagist](https://packagist.org/packages/shuchkin/simplexls)[ Docs](https://github.com/shuchkin/simplexls)[ RSS](/packages/shuchkin-simplexls/feed)WikiDiscussions master Synced 2w ago READMEChangelogDependenciesVersions (20)Used By (3) SimpleXLS ========= [](#simplexls) [![](https://camo.githubusercontent.com/854cd9307a90462938c945044a3f5cb297c0d61992369d51a02170215ec721ce/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f73687563686b696e2f73696d706c65786c73)](https://packagist.org/packages/shuchkin/simplexls) Parse and retrieve data from old Excel .XLS files. MS Excel 97-2003 workbooks PHP reader. PHP BIFF reader. No additional extensions needed (internal olereader). Modern .XLSX php reader [here](https://github.com/shuchkin/simplexlsx). *Hey, bro, please ★ the package for my motivation :) and [donate](https://opencollective.com/simplexlsx) for more motivation!* [**Sergey Shuchkin**](https://www.patreon.com/shuchkin) 2016-2025 Basic Usage ----------- [](#basic-usage) ``` if ( $xls = SimpleXLS::parseFile('book.xls') ) { print_r( $xls->rows() ); // echo $xls->toHTML(); } else { echo SimpleXLS::parseError(); } ``` ``` Array ( [0] => Array ( [0] => ISBN [1] => title [2] => author [3] => publisher [4] => ctry ) [1] => Array ( [0] => 618260307 [1] => The Hobbit [2] => J. R. R. Tolkien [3] => Houghton Mifflin [4] => USA ) ) ``` Installation ------------ [](#installation) ``` composer require shuchkin/simplexls ``` or download class [here](https://github.com/shuchkin/simplexls/blob/master/src/SimpleXLS.php) PHP 5.5-8.4 Basic methods ------------- [](#basic-methods) ``` // open SimpleXLS::parse( $filename, $is_data = false, $debug = false ): SimpleXLS (or false) SimpleXLS::parseFile( $filename, $debug = false ): SimpleXLS (or false) SimpleXLS::parseData( $data, $debug = false ): SimpleXLS (or false) SimpleXLS:parseError(): string // simple $xls->rows($worksheetIndex = 0, $limit = 0): array $xls->readRows($worksheetIndex = 0, $limit = 0): Generator - helps read huge xlsx $xls->toHTML($worksheetIndex = 0, $limit = 0): string // extended $xls->rowsEx($worksheetIndex = 0, $limit = 0): array, values + meta // meta $xls->sheetNames():array $xls->sheetName($worksheetIndex):string ``` Examples -------- [](#examples) ### XLS to html table [](#xls-to-html-table) ``` echo SimpleXLS::parse('book.xls')->toHTML(); ``` or ``` if ( $xls = SimpleXLS::parse('book.xls') ) { echo ''; foreach( $xls->rows() as $r ) { echo ''.implode('', $r ).''; } echo ''; } else { echo SimpleXLS::parseError(); } ``` ### Sheet names [](#sheet-names) ``` if ( $xls = SimpleXLS::parseFile('book.xls') ) { print_r( $xls->sheetNames() ); print_r( $xls->sheetName( $xls->activeSheet ) ); } ``` ``` Array ( [0] => Sheet 1 [1] => Sheet 2 [2] => Sheet 3 ) Sheet 2 ``` ### Sheets info [](#sheets-info) ``` if ( $xls = SimpleXLS::parseFile('book.xls') ) { print_r( $xls->boundsheets ); } ``` ``` Array ( [0] => Array ( [name] => Sheet 1 [offset] => 15870 [hidden] => [active] => ) [1] => Array ( [name] => Sheet 2 [offset] => 16308 [hidden] => 1 [active] => 1 ) [2] => Array ( [name] => Sheet 3 [offset] => 16746 [hidden] => [active] => ) ) ``` ### Classic OOP style [](#classic-oop-style) ``` $xls = new SimpleXLS('books.xls'); if ($xls->success()) { print_r( $xls->rows() ); } else { echo 'xls error: '.$xls->error(); } ``` Debug ----- [](#debug) ``` ini_set('error_reporting', E_ALL ); ini_set('display_errors', 1 ); //header('Content-Type: text/html; charset=utf-8'); $xls = SimpleXLSX::parse('books.xls', false, true ); print_r( $xls->rows() ); print_r( $xls->sheets ); ``` History ------- [](#history) 1.0.0 (2025-03-04) 7 years, 400k downloads, we need release 0.11.1 (2025-02-14) PHP 5.5-8.4 support, fixed datetime cells thx [tomu4](https://github.com/tomu4) 0.10.5 (2024-09-17) readRows() returns Generator, thx [livingroot](https://github.com/livingroot) 0.10.4 (2023-11-13) more compatible with PHP 8.1 0.10.3 (2022-10-04) namespaced examples 0.10.2 (2022-09-01) fixed percent values 0.10.1 (2022-04-04) PHP 7.1+, PHP 8.0+ 0.9.15 (2021-12-01) added `$xls->sheetNames()`, `\$xls->sheetName( $index )`, `$xls->activeSheet` added `$limit` in `$xls->rows( $sheetIndex, $limit = 0 )` more examples in README 0.9.14 (2021-11-04) Detect datetime format 0.9.13 (2021-09-21) Fixed éàù... in sheet names, added flag *hidden* in $xls->boundsheets info 0.9.12 (2021-09-20) Fixed éàù... 0.9.11 (2021-09-02) Added *Rows with header values as keys* example 0.9.10 (2021-05-19) SimpleXLSX to SimpleXLS in example 0.9.9 (2021-03-04) Added `$xls->toHTML()` 0.9.8 (2021-03-04) Fixed skipping first row & col, fixed datetime format in unicode 0.9.7 (2021-02-26) Added `::parseFile()`, `::parseData()` 0.9.6 (2020-12-01) Fixed README 0.9.5 (2020-01-16) Fixed negative number values and datetime values 0.9.4 (2019-03-14) Added git Tag for prevent composer warning 0.9.3 (2019-02-19) Fixed datetime detection 0.9.2 (2018-11-15) GitHub release, composer ### Health Score 50 — FairBetter than 95% of packages Maintenance38 Infrequent updates — may be unmaintained Popularity57 Moderate usage in the ecosystem Community28 Small or concentrated contributor base Maturity65 Established project with proven stability Bus Factor1 Top contributor holds 89.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 Every ~122 days Recently: every ~220 days Total 19 Last Release 532d ago Major Versions 0.11.1 → 1.0.02025-03-03 ### Community Maintainers ![](https://www.gravatar.com/avatar/551f9169d9efadfa85ff5ff512eab17e9219ba10e42636d9a31f1021a1027395?d=identicon)[shuchkin](/maintainers/shuchkin) --- Top Contributors [![shuchkin](https://avatars.githubusercontent.com/u/315872?v=4)](https://github.com/shuchkin "shuchkin (42 commits)")[![idugan100](https://avatars.githubusercontent.com/u/102197130?v=4)](https://github.com/idugan100 "idugan100 (2 commits)")[![DieterHolvoet](https://avatars.githubusercontent.com/u/3606531?v=4)](https://github.com/DieterHolvoet "DieterHolvoet (1 commits)")[![livingroot](https://avatars.githubusercontent.com/u/9570664?v=4)](https://github.com/livingroot "livingroot (1 commits)")[![Maikuolan](https://avatars.githubusercontent.com/u/12571108?v=4)](https://github.com/Maikuolan "Maikuolan (1 commits)") --- Tags phpparserexcelxlsbackend ### Embed Badge ![Health badge](/badges/shuchkin-simplexls/health.svg) ``` [![Health](https://phpackages.com/badges/shuchkin-simplexls/health.svg)](https://phpackages.com/packages/shuchkin-simplexls) ``` ### Alternatives [shuchkin/simplexlsx Parse and retrieve data from Excel XLSx files. MS Excel 2007 workbooks PHP reader. 1.8k4.3M37](/packages/shuchkin-simplexlsx)[mk-j/php_xlsxwriter PHP Library to write XLSX files 1.9k8.8M33](/packages/mk-j-php-xlsxwriter)[avadim/fast-excel-reader Lightweight and very fast XLSX Excel Spreadsheet and CSV Reader in PHP 105786.0k14](/packages/avadim-fast-excel-reader)[avadim/fast-excel-writer Lightweight and very fast XLSX Excel Spreadsheet Writer in PHP 3081.5M13](/packages/avadim-fast-excel-writer)[shuchkin/simplecsv Parse and retrieve data from CSV files. Export data to CSV. 52102.7k2](/packages/shuchkin-simplecsv)[diswebru/phpexcel PHP library for writing and reading files in EXCEL format. Modified to work on PHP 8. 1010.4k](/packages/diswebru-phpexcel) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)