search

donnytian / Npoi.Mapper

Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.
MIT License
599 stars 115 forks source link

Upgrade NPOI to 2.7.1 #139

Open dcjxdd123 opened 3 months ago

dcjxdd123 commented 3 months ago

NPOI 2.7.1 fix https://github.com/donnytian/Npoi.Mapper/issues/136

lerasah commented 2 months ago

@dcjxdd123 I temporarily published a nuget to https://www.nuget.org/packages/Synced.Npoi.Mapper which does the same.. I will remove it once this PR is approved. (I couldn't hold it any longer) Also found https://github.com/mganss/ExcelMapper which does the same.

superjulius commented 6 days ago

@donnytian any potential risk to upgrade to NPOI to 2.7.1?

We are currently locked with 2.6.2 as the mapper fails when upgrading to 2.7.1

System.MissingMethodException: Method not found: 'System.DateTime NPOI.SS.UserModel.ICell.get_DateCellValue()'.
   at Npoi.Mapper.MapHelper.TryGetCellValue(ICell cell, Type targetType, TrimSpacesType trimSpacesType, Object& value, IFormulaEvaluator evaluator)
   at Npoi.Mapper.Mapper.LoadRowData[T](IEnumerable`1 columns, IRow row, T target, RowInfo`1 rowInfo)