Release 3.0

Fix issue #14 and #41 and bring dependencies up to date

• Fix issue #41. The Type Provider should no longer return an extra blank row with the data as it did before.
• Fix issue #14 and related behaviour. We are now better at handling casting of data to the detected data type if there are rows which have data of different data types.
• Both above fixes were contributed by new contributor Matthew Dupont. His contributions are very much appreciated.
• Both fixes, but especially for #41, can break existing code logic. Please test your code after upgrading to this version.

Release 2.1.0

For users of the library

• Fix issue #77. The type provider will no longer revert to the first sheet if the sheet name provided does not exist. Instead, the code will not compile.
• The documentation site has been updated and a number of small issues fixed.

For Developers

• Dependencies have been updated to the latest versions.
• Started using Fantomas. All files now formatted with Fantomas.
• Some build targets in build.fsx have been updated/restored i.e. Format, CheckFormat, Nuget, CleanDocs, GenerateDocs

2.1.0-rc2

In the rc1 release candidate we accidentally included compilerservices and its related dependencies in the nuget file. This release removes that.

2.1.0-rc1

This release fixes issue #77.
Also, dependencies have been updated to use newest dependencies compatible with .net 6.0, the oldest long term release still in support at time of publishing.

What's Changed

• Update tooling to use latest version 6 .NET SDK by @quintusm in #92
• Add contributions from Ingted to fix issues related to to sheet names by @quintusm in #95
• Update Dependencies by @quintusm in #96
• Update dependencies to newest level supported by .net 6 by @quintusm in #97
• Update to version 2.1.0-rc1 by @quintusm in #98

Full Changelog: 2.0.0...2.1.0-rc1

2.0.0

This has all the changes from the various release candidates i.e.

• Only build for NetStandard 2.0. (reason for bump to V2)
• Convert paket to use dotnet tools infrastructure.
• Update FSharp.Formatting to version 11.4.2 and using dotnet tools (fsdocs command line).
• Update to dotnet 5.0 which is newest version of dotnet at time of writing.
• Update to FSharp.Core to 4.7.2.
• Fix issue when file locked by another process.
• Add improved error messages when an invalid cast is attempted.
• Add ability to read from stream instead of file.

2.0.0-rc3

• Add the ability to read from a stream, not only from a file

2.0.0-rc2

• Improve the error message provided when a cast is invalid.

2.0.0-rc1

• ExcelProvider only built as NetStandard binary from this point forward.
• Fixed issue when the file used is locked by another process.
• Updated paket to use dotnet tools version
• Updated FAKE to 5 series
• Updated dependencies

0.8.0

Support Row.GetValue("column") and handle of out-of-range column indexes explicitly - #27

0.7.0

HasHeaders type provider parameter - #26