v3.8.0-develop00498

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

v3.8.0-develop00488

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

v3.8.0-develop00474

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

v3.7.0

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

v3.7.0-develop00415

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

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

v3.7.0-develop00411

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

• Enhancement: Implemented GetValues(object[]) (#578)
• Enhancement: Support multiple header rows in AsDataSet (#518)
• Fix: Slow performance when reading XLSB on .NET (#493)
• Fix: Reading DateTime when date1904 attribute is 'true' (#649)

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)