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
589 stars 114 forks source link

mapper.Take<T>() adding invalid, null row to collection #76

Closed boney0002 closed 2 years ago

boney0002 commented 3 years ago

I'm not sure if I'm doing something wrong, but if I am I don't see where. I am reading in an excel spreadsheet, and using mapper.Take() to map to my class, then doing some validation on each row. The mapper is returning an invalid null row with a row number that does not even exist in my spreadsheet. I go from a valid row, row number 8, to invalid null, row number 11.

Screenshot: Row11 Capture

donnytian commented 2 years ago

please try with the latest version as we upgraded the NPOI version