1.38.0

1.38.0

• [New] feat(DynamicExcelColumn): make the CustomFormatter property more powerful (#715) (via @izanhzh)
• [New] feat(ExcelNumberFormat): extend the SectionType (#716) (via @izanhzh)
• [New] feat(ExcelOpenXmlSheetWriter): adjust the location of the CustomFormatter execution (#722) (via @izanhzh)
• [New] WriteEmptyStringAsNull implementation (#725) (via @jiangyi1985)
• [Bug] Fix @group tag not working with certain IEnumerable types (#723) (via @JamesDSource)
• [OPT] Optimized ContainsKey calls to TryGetValue (via @michelebastione)
• [OPT] Changed Count() method calls to Count property (via @michelebastione)
• [OPT] Materialized some IEnumerables using ToList (via @michelebastione)
• [OPT] Added safe IDisposable cast to IEnumerator (via @michelebastione)
• [OPT] Removed superfluous indentation and parenthesis (via @michelebastione)

1.36.1-1.37.0

1.37.0

• [New] feat: support insert sheet (#709) (via @izanhzh)
• [Bug] fix(MiniExcelDataReader): GetOrdinal always returns 0 (#711) (via @izanhzh)
• [OPT] Generalize excel writing with a common write adapter and implement writing IAsyncEnumerable (#712) (via @Discolai , @izanhzh)

1.36.1

• [New] feat(MiniExcelDataReaderBase): add asynchronous support (#706) (via @izanhzh , @ArgoZhang )

1.36.0

1.36.0

• [New] Write auto column width (#695) (via @Discolai)
• [New] Enhance IDataReader export with DynamicColumnFirst and Custom Formatting Delegate (#700) (via @IcedMango)
• [Bug] If cellValue is string no matter that it contains only numbers will put the value as text. Preventing of losing leading zeroes (via @psyhlo)

1.35.0

1.35.0

• [New] Formula attribute added to support in rows with dto or dynamic attributes (#679) (via @RaZer0k & Co-authored-by: Eulises Vargas )
• [New] Async implementation of freezing top row (#684) (via @BaatenHannes )
• [New] Upgrade to .NET 8.0 and refactor input value extraction (#681) (via @ramioh )
• [Bug] Yield empty self-closing row tags as empty row during query. (#673) (via @aulickiDnv )

1.34.2

1.34.2

• [New] Add MniExcelDataReaderBase class to simplify code (#651) (via @ArgoZhang )
• [OPT] perf csv insert (#653) (via @izanhzh )
• [Bug] Fix dimension writing in FastMode (#659) (via @Discolai )
• [Bug] Fix QueryAsDataTable can't read Excel with only header rows (#647) (via @Discolai )

1.34.1

1.34.1

• [Bug] Fix Issue 632, refactor sheet styles (#640) (via @meld-cp)
• [Bug] Fix StartSheetView for multiple selection (#641) (via @jiaguangli)

1.34.0

1.34.0

• [New] Add freeze panes (#626) (via @meld-cp)
• [New] Add DateTime Nullale support (via @jiaguangli)
• [OPT] Reduce memory requirements when processing templates + template formulas (#638) (via @meld-cp)
• [Bug] Fix problem with multi-line when using Query (#628) (via @meld-cp)
• [Bug] Fix empty data reader issue. (#629) (via @duszekmestre)
• [Bug] Fix Fields of type long cannot be set to text normally #627 (via @shps951023)

1.33.0

1.33.0

• [New] Support Template formulas (#622) (via @meld-cp)
• [New] Update DynamicConfiguration format (#595) (via @wangboshun)
• [OPT] CSV enumeration and code reusage (#600) (via @duszekmestre)
• [OPT] 1900 year DateTime correction #599 (via @duszekmestre)

1.32.1

• [New] .NET5^ support image ReadOnlySpan<byte> (via @shps951023)
• [Bug] Remove bug with Portable.System.DateTimeOnly and only support DateOnly .NET6^ #594 (via @shps951023)

1.32.0

1.32.0

• [New] Using DynamicConfiguration when writing data using DataTable (via @pszybiak)
• [New] Make System.DateOnly available as date in Excel (#576) (via @ofthelit)
• [New] Allow ampersand in sheet names (via @ofthelit)
• [OPT] Use true async processing for excel writer (#573) (via @duszekmestre)
• [Bug] Fix nullable enumeration conversion failure #567) (via @PurplestViper)
• [Bug] IEnumerable traversed twice #422 (via @Discolai)
• [Bug] Fix Read empty string as null (via @pszybiak)
• [Bug] Fix CSV Reader Query faild on specific xlsx file, throws ExcelColumnNotFoundException (via @AZhrZho)
• [Bug] Fix DynamicExcelColumn configuration while saving IDictionary values (via @johannes-barta)
• [Bug] Fix propInfo.Key missing (via @shps951023)
• [Bug] Fix sharedStrings ref #549 (via @shps951023)

1.31.3

1.31.3

• [Bug] DescriptionAttr null check(via @wulaoh)
• [Bug] Throw custom exception when CSV column not found #543 (via @pszybiak)
• [Bug] SaveAsByTemplate rowInfo.IEnumerableMercell.Height null exception #553 (via @shps951023)