Packagist · #1955 most downloaded on Packagist

shuchkin/simplexlsx

1.1.194.7M downloads/moshuchkin/simplexlsx ↗New releases in your daily digest, changelog included.

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

Release timeline

48 releases since 2019

20192020202120222023202420252026

1.0.1813 Oct 20222 sources agree

fixed regex to detect date/datetime in cell

fixed regex to detect date/datetime in cell
added $this->sheetMeta($worksheetIndex = null) to get metadata from workbook.xml
added $this->isHiddenSheet($worksheetIndex)
deleted $this->sheetNemes (use $this-sheetMetadata)

1.0.1221 Feb 20222 sources agree

PHP 5.5+, namespace Shuchkin, 4 spaces indents

1.0 VERSION: Memory and styles
PHP 5.5+, namespace Shuchkin, 4 spaces indents
memory: added readRows() and readRowsEx() returns Generator. Help to read huge files
memory: in my tests ~100k rowsEx() used 880 MB, readRowsEx() used 162 MB
memory: added SimpleXLSXEx companion class for extract styles, used in rowsEx & toHTMLEx() only
styles: alignment, fonts, fills, borders
styles: rowsEx() return style info, cell width & height, css to apply in TD tag
styles: added toHTMLEx() to export worksheet to HTML formatted table
fixed author in license.md
fixed examples

0.8.3030 Nov 20212 sources agree

added $limit to $xlsx->rows( $sheetIndex = 0, $limit = 0 ) and to $xlsx->rowsEx( $seetIndex = 0, $limit = 0)

added $limit to $xlsx->rows( $sheetIndex = 0, $limit = 0 ) and to $xlsx->rowsEx( $seetIndex = 0, $limit = 0)
Anyway SimpleXML loaded all XML data, so memory economy is minimal

0.8.2916 Oct 20212 sources agree

if cell type undefined, then parse it as number

0.8.819 Jun 20192 sources agree

removed list( $x, $y ), added bool $xlsx->skipEmptyRows, $xlsx->parseFile( $filename ), $xlsx->parseData( $data ), release 0.8.8

removed list( $x, $y ), added bool $xlsx->skipEmptyRows, $xlsx->parseFile( $filename ), $xlsx->parseData( $data ), release 0.8.8