All Versions
Latest Version
Avg Release Cycle
103 days
Latest Release
1433 days ago

Changelog History
Page 1

  • v3.7.0-develop00310 Changes

    August 09, 2020

    Highlights in ExcelDataReader 3.7.0-develop00310 since ExcelDataReader 3.7.0-develop00306:

    • ๐Ÿ†• New GetCellError() method returns error enum for a cell
    • ๐Ÿ›  Bugfix: Fixed reading XLS on Unity in some timezones
    • ๐Ÿ›  Bugfix: Fixed "Bad SST format" exception in certain XLS (partial regression since 3.2.0)
  • v3.7.0-develop00306 Changes

    August 02, 2020

    Highlights in ExcelDataReader 3.7.0-develop00306 since 3.6.0:

    • ๐Ÿ‘Œ Support for XLSB format
    • ๐Ÿ†• New GetCellStyle method returns indent, horizontal alignment, hidden, locked for a cell
    • ๐Ÿ›  Bugfix: Fixed reading certain password protected XLS using 40bit keys
    • ๐Ÿ›  Bugfix: Fixed reading XLS with duplicate FORMAT records
    • ๐Ÿ›  Bugfix: Fixed reading XLS with multiple workbook streams
    • ๐Ÿ›  Bugfix: Fixed reading XLS strings with font encoding
    • ๐ŸŽ Performance improvements
  • v3.6.0 Changes

    May 02, 2019

    Highlights in ExcelDataReader 3.6.0 since 3.5.0:

    • ๐Ÿ†• New AnalyzeInitialCsvRows configuration option can speed up reading large CSV files
    • ๐Ÿ›  Bugfix: Fixed reading some XLSX returned no rows. Regression since 3.5.0
  • v3.5.0 Changes

    March 01, 2019

    Highlights in ExcelDataReader 3.5.0 since 3.4.2:

    • ๐Ÿ†• New GetNumberFormatIndex() method returns the index of the built-in or custom number format in a cell
    • ๐Ÿ†• New GetColumnWidth() method returns the width of a column, or 0 if collapsed or hidden
    • ๐Ÿ†• New FilterSheet callback for AsDataSet
    • ๐Ÿ†• New LeaveOpen option leaves the stream open after the IExcelDataReader object is disposed
    • โšก๏ธ Optimized XLS row offset map internals
    • ๐Ÿ›  Bugfix: Improved support for number formats in BIFF2 XLS
    • ๐Ÿ›  Bugfix: Support XLS with non-standard headers, and/or mixed version BIFF records typically generated by third parties
    • ๐Ÿ›  Bugfix: XLS parser throws exceptions derived from ExcelReaderException upon errors
    • ๐Ÿ›  Bugfix: Handle XLSX zip files with backslash
    • Enabled SourceLink
  • v3.4.2 Changes

    October 14, 2018

    Highlights in ExcelDataReader 3.4.2 since 3.4.1:

    • ๐Ÿ›  Bugfix: Fixed reading XLSX where packaging metadata uses nondefault namespace prefix
    • ๐Ÿ›  Bugfix: Fixed reading CSV where last line ends with a separator
  • v3.4.1 Changes

    August 29, 2018

    Highlights in ExcelDataReader 3.4.1 since 3.4.0:

    • โšก๏ธ Optimized CSV parser
    • ๐Ÿ›  Bugfix: Fixed reading CSV with single quotes
    • ๐Ÿ›  Bugfix: Fixed reading cells with error as null in XLSX
    • ๐Ÿ›  Bugfix: Fixed crash when closing XLS and CSV readers more than once
    • ๐Ÿ›  Bugfix: Handle inline formatted text in XLS
    • ๐Ÿ›  Bugfix: Handle XLS with missing EOF record before BOF record
    • ๐Ÿ›  Bugfix: Handle XLSX files with one row element per cell
    • ๐Ÿ›  Bugfix: Fixed compile error in VS2010 in net35 and net40 apps using AsDataSet
  • v3.4.0 Changes

    February 04, 2018

    Highlights in ExcelDataReader 3.4.0 since 3.3.0:

    • ๐Ÿ†• New MergeCells property returns merged cell ranges in the current sheet
    • ๐Ÿ†• New RowCount property returns number of rows in the current sheet
    • ๐Ÿ†• New FilterColumn callback option for AsDataSet()
    • ๐ŸŽ‰ Initial support for reading CSV
    • ๐Ÿ›  Bugfix: Fixed hang when reading certain broken XLS. Regression since 3.3.0
    • ๐Ÿ›  Bugfix: Fixed case insensitive lookup of XLSX ZIP entries
    • ๐Ÿ›  Bugfix: Fixed exceptions reading Compound Document directory entries with bad data
  • v3.3.0 Changes

    November 24, 2017

    Highlights in ExcelDataReader 3.3.0 since 3.2.0:

    • ๐Ÿ’ฅ Support for TimeSpan values. GetValue() returns values of type TimeSpan when the number format contains duration formatting tokens [hh], [mm], or [ss]. This is a breaking change for users who attempted to work around the broken DateTime-based durations before
    • ๐Ÿ†• New IExcelDataReader.GetNumberFormatString() method returns the number format string for a value
    • ๐Ÿ‘Œ Improved performance of Reset() and AsDataSet() methods to compensate for slowness introduced by an XLSX compatibility fix in 3.2.0
    • ๐Ÿ›  Bugfix: Fixed problems reading certain XLS where unfortunately aligned SST contents caused an exception. Regression since 3.2.0
    • ๐Ÿ›  Bugfix: Missing password throws InvalidPasswordException instead of NullReferenceException
    • ๐Ÿ›  Bugfix: Fixed opening XLSX encrypted with the default Excel password
  • v3.2.0 Changes

    September 27, 2017

    Highlights in ExcelDataReader 3.2.0 since 3.1.0:

    • ๐Ÿ‘Œ Support for password protected workbooks
    • ๐Ÿ‘Œ Support for netstandard2.0
    • ๐Ÿ†• New RowHeight property returns the height of the current row
    • ๐Ÿ†• New RowFilter configuration callback option for AsDataSet()
    • AsDataSet() trims trailing blank rows
  • v3.1.0 Changes

    July 23, 2017

    Highlights in ExcelDataReader 3.1.0 since 3.0.0:

    • ๐Ÿ†• New HeaderFooter property contains information about headers and footers
    • ๐Ÿ†• New CodeName property contains the current sheet's VBA code name
    • ๐Ÿ›  Bugfix: Could not read XLS larger than ~15 megabytes
    • ๐Ÿ›  Bugfix: Could not read XLSX formatted text
    • ๐Ÿ“š Includes IntelliSense XML documentation