@adrilo adrilo released this Sep 25, 2017 · 1 commit to master since this release

Assets 2

Improvements:

  • Exposed API to get the last active sheet

Bug fixes:

  • Fixed shared strings XML file using a prefix
  • Fixed shared strings XML Entities auto decode

@adrilo adrilo released this Mar 28, 2017 · 15 commits to master since this release

Assets 2

Improvements:

  • CSV Reader can now read lines of any length and is not limited to 32768 bytes per line
  • It is now possible to create 2 spreadsheets at the same time and have sheets with the same name. Uniqueness is enforced at the workbook level.
  • Improved error message when an invalid sheet name is set
  • Introduced hard limit on the character count for XLSX cells (32,767 characters)

Bug fixes:

  • Fixed parsing of the XLSX spreadsheet dimensions
  • Fixed reading of ODS sheet names
  • Better support for empty rows in XLSX files
  • Better support for cells with custom inner style/phonetic description in XLSX files
  • Calling close() when a writer is already closed no longer causes an error

@adrilo adrilo released this Nov 3, 2016 · 26 commits to master since this release

Assets 2
  • Remove control characters to avoid breaking ODS files
  • Fix crash when writing an empty row from an associative array (XLSX)

@adrilo adrilo released this Oct 19, 2016 · 31 commits to master since this release

Assets 2

Major Enhancements:

  • New option to preserve empty rows when reading
  • New option to disable automatic text wrapping
  • ODS Reader now supports num-rows-repeated attribute

Minor Enhancements:

  • Temporary files are now deleted when an exception is thrown while reading
  • Improve support for custom date formats
  • Empty rows don't get written to file for XLSX Writer

Refactoring:

  • Added internal ReaderOptions
  • Added XMLProcessor to easily process XML files
  • And more...

@adrilo adrilo released this Sep 8, 2016 · 49 commits to master since this release

Assets 2

New features included in this new version:

  • Added support for background color
  • It is now possible to override the default style for the spreadsheet. This leads to a big perf improvement.
  • Empty cells can now have a custom style applied to them

Fixes:

  • Fix for borders support in Excel 2013+
  • Cells formatted as dates for XLSX files should respect the shouldFormatDate option
  • Extended support for prefixed XML files
  • A few other minor/perf changes

@adrilo adrilo released this Jul 11, 2016 · 63 commits to master since this release

Assets 2

This new version contains several fixes/improvements:

  • better support for dates:
    • support for cells formatted as time
    • option to return formatted dates instead of PHP objects
  • ODS reader and writer improvements:
    • support for hyperlinks/inline formatting
    • ODS writer now accepts associative arrays (like other writers)
  • Border support!
  • New option to skip BOM addition in CSV file
  • Numerous fixes to not-so-standard XLSX files. Spout now support spreadsheets with:
    • prefixed XML files
    • missing "uniqueCount" and/or "count" attributes in shared strings table
    • missing cell reference in sheet definition

@adrilo adrilo released this Apr 12, 2016 · 89 commits to master since this release

Assets 2
  • Consistent behavior among all readers when reading cells with leading/ending spaces.
  • Added protection against closing file handles that were not properly created

@adrilo adrilo released this Mar 24, 2016 · 94 commits to master since this release

Assets 2
  • Fixed an issue when writing boolean values to XLSX files - #175
  • Added optional support for custom stream wrappers (only works with CSV) - #176
  • Fixed an issue when reading CSV files which happen to have a EOL delimiter inside an enclosed text - #183
  • Fixed an issue when reading zeros and empty strings from ODS files - #184
  • XLSX and ODS writers did not properly release the file handle - #190

@adrilo adrilo released this Feb 14, 2016 · 110 commits to master since this release

Assets 2

Added support for variable EOL in CSV files

@adrilo adrilo released this Jan 14, 2016 · 117 commits to master since this release

Assets 2
  • Added support for XLSX files that have sheets not defined in order of appearance
  • Fixed bug when parsing large numbers