shuchkin / simplexls
Parse and retrieve data from old format Excel XLS files. MS Excel 97 workbooks PHP reader.
Installs: 350 623
Dependents: 4
Suggesters: 0
Security: 0
Stars: 193
Watchers: 9
Forks: 82
Open Issues: 6
Requires
- ext-mbstring: *
README
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.
Hey, bro, please ★ the package for my motivation :) and donate for more motivation!
Sergey Shuchkin sergey.shuchkin@gmail.com 2016-2024
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
composer require shuchkin/simplexls
or download class here
From 0.10 version supports PHP 7.1+, PHP 8+
0.9.x supports PHP 5.3+
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
XLS to html table
echo SimpleXLS::parse('book.xls')->toHTML();
or
if ( $xls = SimpleXLS::parse('book.xls') ) { echo '<table border="1" cellpadding="3" style="border-collapse: collapse">'; foreach( $xls->rows() as $r ) { echo '<tr><td>'.implode('</td><td>', $r ).'</td></tr>'; } echo '</table>'; } else { echo SimpleXLS::parseError(); }
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
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
$xls = new SimpleXLS('books.xls'); if ($xls->success()) { print_r( $xls->rows() ); } else { echo 'xls error: '.$xls->error(); }
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
0.10.5 (2024-09-17) readRows() returns Generator, thx 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