ExcelDataReader v.3.7.0-develop00385

Highlights in ExcelDataReader 3.7.0-develop00385 since ExcelDataReader 3.7.0-develop00365:

• Enhancement: Support BrtCellRString data in .xlsb files (#635)
• Bugfix: Fix not all data being included when reading .xlsb files on net60 and later (#637)

ExcelDataReader v3.7.0-develop00371

Highlights in ExcelDataReader 3.7.0-develop00371 since ExcelDataReader 3.7.0-develop00365:

• Bugfix: Handle non-standard xlsx file layout (#629)
• Bugfix: Don't preserve leading and trailing whitespace unless xml:space is preserve in xlsx files (#425)
• Bugfix: Ignore empty 0x0000 record (#609)

ExcelDataReader v3.7.0-develop00365

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

• Added TransformValue callback to ExcelDataTableConfiguration (#486)
• Added support for Strict Open XML files (#498)
• Skip empty trailing columns (#532)

ExcelDataReader v3.7.0-develop00310

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)

ExcelDataReader 3.7.0-develop00306

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

ExcelDataReader 3.6.0

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

ExcelDataReader 3.5.0

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

ExcelDataReader 3.4.2

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

ExcelDataReader 3.4.1

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

ExcelDataReader 3.4.0

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