- Fix for formulas being returned along with values in XLSX files. (Thanks to marktag)
- Fix for macro sheets appearing when parsing XLS files. (Thanks to osuwariboy)
- Fix for a PHP warning that occurs with completely empty sheets in XLS files.
- XLSM (macro-enabled XLSX) files are recognized and read, too.
- composer.json file is added to the repository (thanks to matej116)
- Fix for repeated columns in ODS files not reading correctly (thanks to etfb)
- Fix for filename extension reading (Thanks to osuwariboy)
- A fix for the case when row count wasn't read correctly from the sheet in a XLS file.
-
Fixed file type choice when using mime-types (previously there were problems with
XLSX and ODS mime-types) (Thanks to incratec) -
Fixed an error in XLSX iterator where
current()
would advance the iterator forward
with each call. (Thanks to osuwariboy)
-
Multiple sheet reading is now supported:
- The
Sheets()
method lets you retrieve a list of all sheets present in the file. ChangeSheet($Index)
method changes the sheet in the reader to the one specified.
- The
-
Previously temporary files that were extracted, were deleted after the SpreadsheetReader
was destroyed but the empty directories remained. Now those are cleaned up as well.
- Bugfix for shared string caching in XLSX files. When the shared string count was larger
than the caching limit, instead of them being read from file, empty strings were returned.
- XLS file reading relies on the external Spreadsheet_Excel_Reader class which, by default,
reads additional information about cells like fonts, styles, etc. Now that is disabled
to save some memory since the style data is unnecessary anyway.
(Thanks to ChALkeR for the tip.)
Martins Pilsetnieks [email protected]