1.45.0

Summary

This release adds .NET Framework 4.6.1 as an explicit target framework to the library.
This was done because projects targeting the full framework would install through NuGet the closest matching version to their compilation target, said version being .NET 4.5 instead of the preferred netstandard2.0. This had the most notable effect of IAsyncEnumerables not being supported as exportable data sources.

What's Changed

• Added net461 compilation target by @michelebastione in #978

Full Changelog: 1.44.1...1.45.0

2.0.0 Preview 4

This release brings bug fixes, new features and quality of life improvements, such as proper number/datetime format serialization, resource based localization for the column attributes, support for querying named tables, dynamic sheet generation for templates and more!
This will most likely be the last pre-release version before the full fledged v2 release, so please do try it out and send feedback if you can, it would be very appreciated!

What's Changed - Details

• Added check to OpenXmlValueExtractor to eclude indexers from property mapping by @michelebastione in #952
• Enhanced formatting capabilities by @michelebastione in #955
• Refactoring of string data handling in OpenXmlWriter by @michelebastione in #961
• Fixed issue with generated documents unable to be accessed thrugh OleDb connector by @michelebastione in #962
• Adds new CopyAndAddSheet API to OpenXmlExporter by @michelebastione in #965
• Added polyfills and simplified preprocessor directives by @michelebastione in #966
• Added resource-based localization for column attributes by @michelebastione in #967
• Documentation Improvements by @michelebastione in #968
• Added support for querying arbitrary named tables by @michelebastione in #969
• Reorganizing tests by @michelebastione in #970
• Expanded data reader capabilities by @michelebastione in #971
• Added support for dynamic sheet generation and nested properties for templates by @iyumot in #959

New Contributors

• @iyumot made their first contribution in #959

Full Changelog: 2.0.0-preview.3...2.0.0-preview.4

1.44.1

Summary

This release is a hotfix for an oversight that prevented numerical string values to be recognized as text by Excel when explicitly exported with the "@" format.

What's Changed

• Fixed issue 627 by @michelebastione in #960

Full Changelog: 1.44.0...1.44.1

1.44.0

Added proper numerical formatting for numbers, dates and times

This release addresses a long standing issue with regards to the MiniExcelFormatAttribute.

Prior to this update all values of the properties it was used upon would be converted to their string representation according to the specified format, instead of being exported as is and linked to a style element like the OpenXml specification suggests.
This prevented the results to be used as actual numerical values, e.g. in formulas, while still retaining their representation.

With this update the inconvenience has mostly been solved, as the following types will now be exported preserving their intended value:

• Unmanaged numerical types (int, long, double, decimal, etc...)
• DateTime, DateTimeOffset and DateOnly
• TimeSpan and TimeOnly

---

All changes

• Fixes issues 951 (backported from the main branch) and 954 by @michelebastione in #956
• Backported PR 955 enhancing formatting capabilities by @michelebastione in #957

Full Changelog: 1.43.1...1.44.0

2.0.0 Preview 3

After a bit of a hiatus since the last preview version, this one brings many fixes and new features. There will be one more preview release after this one, but a full fledged v2 release will most likely follow shortly after.

New Features - Summary

• The OpenXml logic has been decoupled from all the abstractions, making it possible for this version to be released under 4 different packages: MiniExcel.Core for the abtractions, MiniExcel.OpenXml for the OpenXml functionalities, MiniExcel.Csv for the csv functionalities, and finally the full package MiniExcel.
• Public fields can now get mapped for importing and exporting, not by default but when marked with MiniExcelColumnAttribute or any other MiniExcel attribute.
• It is now possible to hide columns when exporting a worksheet by marking the respective property with MiniExcelHiddenAttribute or MiniExcelColumnAttribute.Hidden.
• OpenXmlImporter has been enhanced with new method RetrieveCommentsAsync, allowing for retrieval of both threaded comments and legacy notes from a worksheet.
• OpenXmlExporter has been enhanced with new method AlterWorksheetAsync, allowing for editing an existing worksheet's name, index and visibility state.
• The implementation of MiniExcelDataReader has been extended, turning it into a fully functional IDataReader.
• The RightToLeft parameter was added to OpenXmlConfiguration allowing for a worksheet to be displayed in Excel in a RTL manner.
• It is now possible to choose horizontal and vertical cell alignment for the whole column rather than only for the header through the OpenXmlConfiguration.StyleOptions.

What's Changed - Details

• Fix #905: Release the internally created IAsyncEnumerator by @izanhzh in #906
• New github report templates by @michelebastione in #908
• docs: add horizontal fill workaround by @meiranzheng in #912
• Fix template export generating corrupted Excel files by @A-nony-mous in #917
• Moved OpenXml specific logic to new MiniExcel.OpenXml project by @michelebastione in #918
• Ignoring empty rows in csv files by @michelebastione in #923
• Added async implementation for GenerateSheetXmlImplByCreateMode by @michelebastione in #925
• Fixes Issue 915 by @michelebastione in #924
• Added right-to-left layout exporting capability by @michelebastione in #927
• Changed logic behind identification of special template values by @michelebastione in #928
• MiniExcelDataReader refactoring by @michelebastione in #929
• Refactored column width writing logic by @michelebastione in #930
• Adds mapping fields capability by @michelebastione in #931
• Adds hidden columns functionality by @michelebastione in #932
• Fixed minor edge case bug in enum mapping by @michelebastione in #933
• Added explicit flag for overwriting result file when applying a template by @michelebastione in #934
• Refactoring of the templating system by @michelebastione in #936
• Cell alignment support by @2399087410 in #938
• Revised and patched the workflow for exporting data to OpenXml asynchronously by @michelebastione in #939
• Optimized write adapters and improved code clarity by @michelebastione in #940
• Enhanced OpenXmlImporter with new functionality for retrieving comments and notes by @michelebastione in #941
• Changing templating system from XmlDocument based to XDocument based by @michelebastione in #946
• Added API for editing a worksheet's properties by @michelebastione in #949
• Preparations for release of preview version 3 by @michelebastione in #950

New Contributors

• @meiranzheng made their first contribution in #912
• @A-nony-mous made their first contribution in #917
• @2399087410 made their first contribution in #938

Full Changelog: 2.0.0-preview.2...2.0.0-preview.3

1.43.1

What's Changed

• Fixed headers being printed when using SaveAsAsync despite ExcelIgnore property set to true on DynamicExcelColumn by @michelebastione in #937
• Backports background color and text alignment style options from v2.x by @michelebastione in #945
• Preparations for v1.43.1 release by @michelebastione in #948

Full Changelog: 1.43.0...1.43.1

1.43.0

What's Changed

This release brings the following features and fixes:

New Features

• Adds RightToLeft parameter in OpenXmlConfiguration to make worksheets being displayed in a right-to-left layout when opened in Excel by @michelebastione in #935 (mirrors #927)
• Adds the ExcelHiddenAttribute that, when used to decorate a property, hides the mapped column in Excel by @michelebastione in #935 (mirrors #932)

Bugfixes

• Fixes IAsyncEnumerator not being properly disposed in AsyncEnumerableWriteAdapter, leading to database connections not being released by @izanhzh and @michelebastione in #907 (mirrors #906)
• Fixed an error that resulted in corrupted Excel files when filling a template by @A-nony-mous and @michelebastione in #926 (mirrors #917)
• Fixes empty or whitespace rows breaking the parsing of csv files by @michelebastione in #926 (mirrors #923)
• Fixes numeric value not being passed in a culturally invariant format to template cells when being fetched from a Dictionary or a DataTable by @michelebastione in #926 (mirrors #924)
• Fixes cells in Excel templates containing strings such as @group (like in some emails) to be mistakenly identified as template parameters by @michelebastione in #935 (mirrors #928)
• Refactored column width writing logic to default to Excel's 8.43 characters (64px) and taking padding into account by @michelebastione in #935 (mirrors #930)

Full Changelog: 1.42.0...1.43.0

2.0.0 Preview 2

New Pre-Release Version

Big milestone reached with the implementation of a Fluent Mapper. It allows for a powerful new way to use MiniExcel, giving you finer grained control over the way you can map Excel sheets to your objects and collections! Read more about it in the docs.
Thanks to everyone who tried out our previous pre-release and sent feedback! We're getting close to a full v2 release, stay tuned for updates!

What's Changed

• Added support for new Fluent Mapping configuration by @CoreyKaylor in #850
• Added DateTime to DateOnly conversion by @RiRiSharp in #870
• Minor doc changes by @michelebastione in #872
• PR #870 oversight fix by @michelebastione in #874
• Fixed exception not being thrown when too long a sheet name was passed as dictionary key by @michelebastione in #878
• Added custom exception for indexers being treated as properties during serialization by @michelebastione in #884
• Exposed IProgress for Exports by @mukunku in #883
• Fixed two edge cases with the mapping of double types by @michelebastione in #886
• Fixed #888 by ignoring empty rows on reading by @paulroho and @michelebastione in #893
• Changed shared strings cache default path and added option to customize it by @michelebastione in #897
• Updated projects, tests and samples as part of a refactoring following the release of .NET 10 by @michelebastione in #900

New Contributors

• @RiRiSharp made their first contribution in #870
• @mukunku made their first contribution in #883
• @CoreyKaylor made their first contribution in #850

Full Changelog: 2.0.0-preview.1...2.0.0-preview.2

1.42.0

What's Changed

• Added custom exception for indexers being treated as properties during serialization by @michelebastione in #885
• Fixed two edge cases with the mapping of double types by @michelebastione in #887
• Fix #888: Ignore empty rows on read by @paulroho in #890
• Changed the default location where the shared strings cache is stored and added option to customize it by @michelebastione in #898
• Added .net10.0 as a target framework to all projects and other related changes by @michelebastione in #899

New Contributors

• @paulroho made their first contribution in #890

Full Changelog: 1.41.4...1.42

1.41.4

1.41.4

• [Bug] Fixed issue where formulas were not being replaced in templates (#876) (via @michelebastione)
• [Bug] Mirrored fix for issue #869 from master branch to maintenance branch (#873) (via @michelebastione)
• [Bug] Fixed formulas not being replaced in templates (#869) (via @ethanlin6)
• [New] Made SaveAsByTemplate overload with Stream template parameter public and callable via API (#838) (via @michelebastione)