ExcelNPOIStorage FieldNotFoundException when trying to open excel workbook

[lipchev]

I'm getting a FieldNotFoundException stating that

Field not found: 'NPOI.SS.UserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK'.

at FileHelpers.ExcelNPOIStorage.ExcelNPOIStorage.OpenWorkbookFromStream(Stream stream)

This has started happening since before the latest release but I thought it was some hiccup with nuget dependencies. However, now that there is new release I thought I'd give it another go- and still found myself stuck at the opening line.. I've tested with two applications that used to work with

  <package id="FileHelpers" version="3.3.0" targetFramework="net472" />
  <package id="FileHelpers.ExcelNPOIStorage" version="3.3.0" targetFramework="net472" />
  <package id="NPOI" version="2.2.1" targetFramework="net472" />
  <package id="SharpZipLib" version="0.86.0" targetFramework="net472" />

As is the case with this example..

The issue occurs with both xls & xlxs types (opened in the standard manner). I've tested with the latest versions:

  <package id="FileHelpers" version="3.4.2" targetFramework="net472" />
  <package id="FileHelpers.ExcelNPOIStorage" version="3.4.2" targetFramework="net472" />
  <package id="NPOI" version="2.5.1" targetFramework="net472" />
  <package id="Portable.BouncyCastle" version="1.8.6" targetFramework="net472" />
  <package id="SharpZipLib" version="1.3.1" targetFramework="net472" />

[miragejb]

Is there a workaround for this?

[lipchev]

Not as far as I'm aware- I'm sticking with the versions from the first comment- I think those are the latest that work (not 100% sure).
Also- based on the statement from the main page it seems like this might be the end of the line:

We do not have any plans to port the FileHelpers.ExcelNPOIStorage nor FileHelpers.ExcelStorage to .NET Core or .NET Standard.

[miragejb]

What version(s) are you using that work?

[virco]

NPOI 2.4.1 is the last compatible version with [ExcelNPOIStorage].
Is there are plans to integrate the latest version of NPOI?