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)

2.0.0 Preview 1

2.0.0-preview.1

This is a fairly big step for MiniExcel: we've added full support for asynchronous queries through IAsyncEnumerable and restructured the project adding a modular API, planning to expand it into separate packages. There's more to come on the way, so stay tuned! Meanwhile, please try out the current preview and leave some feedback! And check out the new Docs and the Upgrade Notes for details and breaking changes.

---

• Fixed bug that made the DynamicExcelColumn property Ignore not work when generating using an IDataReader as source by @michelebastione in #786
• Added option to quote csv values containing whitespaces, fixed benchmark workflow file, other minor changes by @michelebastione in #790
• [bugfix] enable async style builder setting cell wrap text by @kasimLZ in #795
• WIP: add NPOI benchmark code by @tonyqus in #796
• Adding methods from NPOI to the benchmarks by @tonyqus in #798
• refactor(ExcelReader): restructure the code by @izanhzh in #797
• Fixed phoneticPr for correct XML order; ensure conditionalFormat is not duplicated by @ethanlin6 in #802
• Replace Task.Run wrappers with real asynchronous methods by @virzak in #799
• Minor corrections to #799 by @virzak in #808
• refactor: auto-generate sync methods by @izanhzh in #807
• Restore performance by returning bool instead of object in TryGetMergeCellsAsync by @virzak in #813
• fix: multiple empty rows in query result due to empty first row by @izanhzh in #811
• 1 41 3 fix bugs by @shps951023 in #818
• Revert "1 41 3 fix bugs" by @michelebastione in #820
• Big refactoring before first beta release by @michelebastione in #821
• Remove .NET 9 and add .NET 10; remove .NET Framework 4.6.2 which is still being covered by .NET standard 2.0 by @virzak in #825
• Replace image chart with mermaid by @virzak in #829
• Separating project into different assemblies by @michelebastione in #828
• Fixes formulas not being replaced in templates by @michelebastione in #846
• Extending the header style in OpenXmlStyleOptions by @dazhu6666 in #841
• New readme for v2.0 by @michelebastione in #855
• Update language links and improve README formatting by @shps951023 in #865
• Update project structure and restore core functionality by @shps951023 in #866

New Contributors

• @kasimLZ made their first contribution in #795
• @tonyqus made their first contribution in #796
• @virzak made their first contribution in #799
• @dazhu6666 made their first contribution in #841

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

1.41.3

1.41.3

• [New] Adding QuoteWhitespaces option to CsvConfiguration for adding double quotes to string containing whitespaces #790 (via @michelebastione )
• [Bug] Fixed bug that made the DynamicExcelColumn property "Ignore" not work when generating using an IDataReader as source #584 (via @michelebastione )
• [Bug] v1.41.2 AddPicture not working #814 (via @shps951023)
• [Bug] v1.41.1 AddPicture image max column and row are 2 cells #815 (via @shps951023)
• [Bug] AddPicture get error same export file and second time. #816 (via @shps951023)

1.41.2

1.41.2

• [New] Fixes enum behaviour and adds support for DescriptionAttribute when saving by template (via @michelebastione )
• [Bug] SaveAsByTemplate - Excel Dimension Xml is null #459 (via @michelebastione )
• [Other] Benchmarks refactoring and adaptation for making them run on Github Actions (#777) (via @michelebastione )
• [Other] add deepwiki link and badge (via @isdaniel )

1.41.1

1.41.1

• [New] Added sheet dimensions feature (#774) (via @michelebastione)
• [Bug] Fix Saving by template introduces unintended value replication in each row #771
  (via @shps951023)
• [Bug] SaveAsByTemplate not working in > v1.39.0 for templates with columns past Z #773 (via @shps951023)
• [Bug] Fix Excel style.xml duplicate numFmtId, system error: An item with the same key has already been added. #772 (via @shps951023)

1.41.0

1.41.0

• [New] MiniExcel AddPicture #770 (via @shps951023)
• [New] Add a configuration item in OpenXmlConfiguration to control writing the file path, enabling the corresponding cell to remain empty when importing images. (via @DotNetFans)

1.40.1

1.40.1

• [New] Added support for DateOnly type in query mapping (via @michelebastione)
• [New] Added StyleOptions class to OpenXmlConfiguration to allow more direct control over cell styles (#761) (via @michelebastione)
• [Bug] Fix SaveAsByTemplate empty generated result (via @shps951023)

1.40.0 SaveAsByTemplate Max Memory Usage 6x Saving

1.40.0

• [New] Added exception to warn for sheet name too long (via @michelebastione)
• [New] Added options for trimming column names and ignoring empty rows (via @michelebastione)
• [New] Added IAsyncDisposable calls to ExcelOpenXmlsheetWriter.Async (via @michelebastione)
• [New] Add conditional formatting support to Excel template (#745) (via @Notallthatevil)
• [New] Add support for .NET 9.0 in project file (#744) (via @Notallthatevil)
• [Bug] Bugfix of invalid cell values being mistakenly parsed as valid (via @michelebastione)
• [Bug] Changing NotImplementedException assert in some tests to NotSupportedException (via @michelebastione)
• [Bug] Moved sheet name check and fixed datetime formatting bug (via @michelebastione)
• [OPT] Optimize max memory usage of SaveAsByTemplate #750 (#752) (via @shps951023)
• [OPT] Optimization of SaveAsTemplate method (#749) (via @michelebastione)
• [OPT] Removing DateTimeHelper.FromOADate and related code (via @michelebastione)
• [OPT] Remove redundant property in csproj file (#748) (via @AZhrZho)