What's Changed

• Add support for reading XLM (Macro Sheet) files by @hughbe in #724
• Added CaseSentitive to ExcelDataTableConfiguration. by @kevin-frugier in #732
• Add a DataTable Configuration for allows fill the empty cells in merged range to fill by left-top cell value by @Flithor in #730
• Add locale-aware overload for GetNumberFormatString… by @appel1
• Fix locale-specific built-in number format indices (27-81) not detect… by @appel1 in #736
• Make clipboard selection dimension properties available by @Sebastian-roko in #720
• Add single-pass mode for better performance if you don't need actual field count by @appel1 in #738
• Throw more explicit errors for corrupt files by @appel1 in #739
• Add opt-in EscapeChar support for backslash-escaped CSV quoted fields by @appel1 in #743
• Fix builtin time format locale by @appel1 in #744
• Allow 0xFEFF as byte order in compound document header (#695) by @appel1 in #746
• Fix MergeCells returning null for XLS files without merged cells by @appel1 in #747
• Treat XLS BOOLERR cells as non-empty by @appel1 in #754

New Contributors

• @hughbe made their first contribution in #723
• @kevin-frugier made their first contribution in #732
• @Flithor made their first contribution in #730
• @Sebastian-roko made their first contribution in #720

Full Changelog: v3.8.0...v3.9.0

What's Changed

• Add opt-in EscapeChar support for backslash-escaped CSV quoted fields by @appel1 in #743
• Fix builtin time format locale by @appel1 in #744
• Allow 0xFEFF as byte order in compound document header (#695) by @appel1 in #746
• Fix MergeCells returning null for XLS files without merged cells by @appel1 in #747

Full Changelog: v3.9.0-develop00574...v3.9.0-rc1

What's Changed

• Remove bad performance optimization experiment by @appel1 in #742
• Replace Configuration.Culture with GetNumberFormatString(int, IFormatProvider) overload

Full Changelog: v3.9.0-develop00565...v3.9.0-develop00574

What's Changed

• Fix build and tests on mac by @hughbe in #723
• Add support for reading XLM (Macro Sheet) files by @hughbe in #724
• Added CaseSentitive to ExcelDataTableConfiguration. by @kevin-frugier in #732
• Add a DataTable Configuration for allows fill the empty cells in merged range to fill by left-top cell value by @Flithor in #730
• Add Culture configuration option to return locale-aware format string… by @appel1 in #737
• Fix locale-specific built-in number format indices (27-81) not detect… by @appel1 in #736
• Make clipboard selection dimension properties available by @Sebastian-roko in #720
• Add single-pass mode and reduce allocations 28–56% by @appel1 in #738
• Throw more explicit errors for corrupt files by @appel1 in #739

New Contributors

• @hughbe made their first contribution in #723
• @kevin-frugier made their first contribution in #732
• @Flithor made their first contribution in #730
• @Sebastian-roko made their first contribution in #720

Full Changelog: v3.8.0...v3.9.0-develop00565

What's Changed

New features

• Issue #642: Active Tab/Sheet Support by @john-blackline in #685
• Add CustomQuoteCharacter for reading csv files by @christopherGdynia in #689
• Config property to control trimming whitespaces in CSV parser by @Hasan-75 in #696
• Performance improvements

Fixes

• Use LocalName instead of Name to fix #682 by @appel1 in #683
• Fix for lower case cell reference reading ("a1" vs "A1"). by @Ctrl-Alt-Delight in #684
• Issue #700: Fixed parsing of horizontal alignment in XmlStylesReader by @msjoblad in #702
• Fixed TimSpan Parsing by @Hasan-75 in #697
• Issue 694: Fix timespan parsing for invalid iso values by @yfa-vagelis in #705
• Fix: Preserve ideographic space (U+3000) when trimming XML cell content by @koshi-yasuda in #712
• Issue 711: Fix xml row height parsing by @yfa-vagelis in #715

New Contributors

• @arialdomartini made their first contribution in #679
• @Ctrl-Alt-Delight made their first contribution in #684
• @john-blackline made their first contribution in #685
• @christopherGdynia made their first contribution in #689
• @msjoblad made their first contribution in #702
• @Hasan-75 made their first contribution in #697
• @yfa-vagelis made their first contribution in #705
• @koshi-yasuda made their first contribution in #712

Full Changelog: v3.7.0...v3.8.0

What's Changed

• Fix: Preserve ideographic space (U+3000) when trimming XML cell content by @koshi-yasuda in #712
• Fix: HorizontalAlignment.Centered breaking change by @appel1 in d5d6640

New Contributors

• @koshi-yasuda made their first contribution in #712

Full Changelog: v3.8.0-develop00488...v3.8.0-develop00498

What's Changed since v3.8.0-develop00474

• Issue 694: Fix timespan parsing for invalid iso values by @yfa-vagelis in #705
• Fix reading encrypted .xls files in netstandard 2.1 target in d8b5fe7
• Read vertical alignment in 6408300
• Performance improvements

New Contributors

• @yfa-vagelis made their first contribution in #705

Full Changelog: v3.8.0-develop00474...v3.8.0-develop00488

Highlights in ExcelDataReader v3.8.0-develop00474 since 3.7.0:

• Active Tab/Sheet Support by @john-blackline in #685
• Add CustomQuoteCharacter for reading csv files by @christopherGdynia in #689
• Config property to control trimming whitespaces in CSV parser by @Hasan-75 in #696
• Bugfix: Use LocalName instead of Name to fix #682 by @appel1 in #683
• Bugfix: Fix for lower case cell reference reading ("a1" vs "A1") by @Ctrl-Alt-Delight in #684
• Bugfix: Fixed parsing of horizontal alignment by @msjoblad in #702
• Bugfix: Fixed TimSpan parsing by @Hasan-75 in #697
• Performance improvements

What's Changed

New features

• Support .xlsb files by @appel1 in #444
• Read Strict Open XML Excel files by @monikalaks in #531
• Implement GetValues(object[] values), fix issue 578. by @Andreybonfi in #644
• Allow user defined ReadHeader method to control DataTable column… by @jgilbert2017 in #577

Fixes

• More extensive support for XF records; expose cell styles by @andersnm in #430
• Ignore FORMAT records with a duplicate Index. by @appel1 in #419
• Fix GetCellStyle for .xls files in some cases by @appel1 in #439
• Handle duplicate number format records by using the first one. by @appel1 in #455
• Null check for GetCellError() by @RRobbins94 in #485
• Ignore trailing columns. by @appel1 in #533
• Fix for parsing worksheet column without "width" attribute. by @mathias-ho in #610
• Remove allocation in ReferenceHelper.ParseReference by @OwnageIsMagic in #617
• Resolve paths from .rels file instead of assuming most things are in … by @appel1 in #638
• Handle the partial-byte-reads-in-stream breaking change in .NET6 by @PanosKousidis in #645
• Assorted refactorings and optimizations: by @Lehonti in #640
• Handle both 1 and true values when parsing the date1904 attribute by @eJJonatah in #650
• Prefer separator with more fields if there are more than one separato… by @appel1 in #671

New Contributors

• @RRobbins94 made their first contribution in #485
• @mathias-ho made their first contribution in #610
• @OwnageIsMagic made their first contribution in #617
• @monikalaks made their first contribution in #531
• @PanosKousidis made their first contribution in #645
• @Lehonti made their first contribution in #640
• @skarth1k made their first contribution in #667
• @Andreybonfi made their first contribution in #644
• @IgorMenshikov made their first contribution in #656
• @jgilbert2017 made their first contribution in #577
• @eJJonatah made their first contribution in #650

Full Changelog: v3.6.0...v3.7.0

Highlights in ExcelDataReader 3.7.0-develop00415 since ExcelDataReader 3.7.0-develop00411:

• Improve separator autodetection for csv files (#463 and #500)