Skip to content

Latest commit

 

History

History
314 lines (173 loc) · 6.69 KB

CHANGELOG.md

File metadata and controls

314 lines (173 loc) · 6.69 KB
Raw

Changelog

1.1.13 (2024-12-21)

  • fixed css colors vulnerability

1.1.12 (2024-12-11)

  • fixed toHTMLEx css vulnerability

1.1.11 (2024-07-06)

1.1.10 (2023-04-27)

  • Cell comments returns in rowsEx
  • hyperlinks moved to rowsEx
  • all fields and methods public now
  • helper methods is static now

1.0.21 (2023-04-09)

  • fixed activeSheet(Tab)

1.0.20 (2023-04-05)

  • fixed activeSheet(Tab)

1.0.18 (2023-02-04)

  • 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.17 (2022-10-13)

  • fixed readRowsEx (Undefined index: fontId)

1.0.16 (2022-03-18)

  • fixed rowsEx(), format returns now

1.0.15 (2022-03-11)

  • Added requirements PHP 5.5+ in composer.json and README.md

1.0.14 (2022-03-01)

  • PHP 5 generators capability, thx maxiben

1.0.13 (2022-02-22)

  • fixed basic usage example

1.0.12 (2022-02-21)

  • 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.9.11 (2022-02-05)

  • type "str" (formula and value)

0.9.10 (2022-02-04)

  • class namespaced as Shuchkin\SimpleXLSX
  • fixed reading from XML datetime as float and datetime as ISO

0.8.33 (2022-01-23)

  • getting xml error

0.8.32 (2022-01-22)

  • added LIBXML_COMPACT | LIBXML_PARSEHUGE

0.8.31 (2021-12-01)

  • added $xlsx->activeSheet (thx reptile)

0.8.30 (2021-12-01)

  • 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.29 (2021-10-28)

  • prevent not exists cols notice
  • if cell type undefined, then parse it as number

0.8.27 (2021-09-30)

  • [] to array() for PHP 5.2 backward compatibility. Tested from PHP 5.2.7 to 8.0.9

0.8.26 (2021-08-24)

  • Fixed datetime type detection

0.8.25 (2021-07-28)

  • ::rowsEx() - returns hidden flag, for hidden cells

0.8.24 (2021-05-18)

  • Extract internal links

0.8.23 (2021-04-20)

  • x10 fastest getCell, thx Jonowa
  • for xpath idea / all private methods protected now.

0.8.22 (2021-04-20)

  • fixed lost hash of hyperlinks

0.8.21 (2021-01-11)

  • libxml_disable_entity_loader and PHP 8, thx iKlsR

0.8.19 (2020-07-28)

  • fixed empty shared strings xml

0.8.18 (2020-07-21)

  • fixed hyperlinks

0.8.17 (2020-06-15)

  • fixed version number, added relative pathes a/../b support in relations

0.8.16 (2020-06-14)

  • fixed abs pathes in relations

0.8.15 (2020-04-28)

0.8.14 (2020-04-03)

  • fixed Office for Mac relations

0.8.13 (2020-02-19)

  • removed skipEmptyRows property (xml optimization always), added static parseFile & parseData

0.8.12 (2020-01-22)

  • remove empty rows (opencalc)

0.8.11 (2020-01-20)

  • changed formats source priority

0.8.10 (2019-11-07)

  • skipEmptyRows improved

0.8.9 (2019-08-15)

  • fixed release version

0.8.8 (2019-06-19)

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

0.8.7 (2019-04-18)

  • empty rows fixed, release 0.8.7

0.8.6 (2019-04-16)

  • 1900/1904 bug fixed

0.8.5 (2019-03-07)

  • SimpleXLSX::ParseErrno(), $xlsx->errno() returns error code

0.8.4 (2019-02-14)

  • detect datetime values, mb_string.func_overload=2 support .!. Bitrix

0.8.3 (2018-11-14)

  • getCell - fixed empty cells and rows, safe now, but very slow

0.8.2 (2018-11-09)

  • fix empty cells and rows in rows() and rowsEx(), added setDateTimeFormat( $see_php_date_func )

0.8.1

  • rename simplexlsx.php to SimpleXLSX.php, rename parse_error to parseError fix _columnIndex, add ->toHTML(), GNU to MIT license

0.7.13 (2018-06-18)

  • get sheet indexes bug fix

0.7.12 (2018-06-17)

  • $worksheet_id to $worksheet_index, sheet numeration started 0

0.7.11 (2018-04-25)

  • rowsEx(), added row index "r" to cell info

0.7.10 (2018-04-21)

  • fixed getCell, returns NULL if not exits

0.7.9 (2018-03-17)

  • fixed sheetNames() (namespaced or not namespaced attr)

0.7.8 (2018-01-15)

  • remove namespace prefixes (hardcoded)

0.7.7 (2017-10-02)

  • XML External Entity (XXE) Prevention (]>)

0.7.6 (2017-09-26)

  • if worksheet_id === 0 (default) then detect first sheet (for LibreOffice capabilities)

0.7.5 (2017-09-10)

  • ->getCell() - fixed

0.7.4 (2017-08-22)

  • ::parse_error() - to get last error in "static style"

0.7.3 (2017-08-14)

  • ->_parse fixed relations reader, added ->getCell( sheet_id, address, format ) for direct cell reading

0.7.2 (2017-05-13)

  • ::parse( $filename ) helper method

0.7.1 (2017-03-29)

  • License added

0.6.11 (2016-07-27)

  • fixed timestamp()

0.6.10 (2016-06-10)

  • fixed search entries (UPPERCASE)

0.6.9 (2015-04-12)

  • $xlsx->datetime_format to force dates out

0.6.8 (2013-10-13)

  • fixed dimension() where 1 row only, fixed rowsEx() empty cells indexes (Daniel Stastka)

0.6.7 (2013-08-10)

  • fixed unzip (mac), added $debug param to _constructor to display errors

0.6.6 (2013-06-03)

  • +entryExists()

0.6.5 (2013-03-18)

  • fixed sheetName()

0.6.4 (2013-03-13)

  • rowsEx(), _parse(): fixed date column type & format detection

0.6.3 (2013-03-13)

  • rowsEx(): fixed formulas, added date type 'd', added format 'format' dimension(): fixed empty sheet dimension + sheetNames() - returns array( sheet_id => sheet_name, sheet_id2 => sheet_name2 ...)

0.6.2 (2012-10-04)

  • fixed empty cells, rowsEx() returns type and formulas now

0.6.1 (2012-09-14)

  • removed "raise exception" and fixed _unzip

0.6 (2012-09-13)

  • success(), error(), __constructor( $filename, $is_data = false )

0.5.1 (2012-09-13)

  • sheetName() fixed

0.5 (2012-09-12)

  • sheetName()

0.4

  • sheets(), sheetsCount(), unixstamp( $excelDateTime )

0.3

  • fixed empty cells (Gonzo patch)