All Versions
12
Latest Version
Avg Release Cycle
103 days
Latest Release
954 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