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

Npoi.Mapper - excel file mapping hanged. #115

Closed darshana2000 closed 1 year ago

darshana2000 commented 1 year ago

I have been working on excel file upload which consisting rows around 25k records.

  1. File size is usually around 30 MB and upload failed due to mapper issue. Mapper mapper = new Mapper(stream3) = >//hanged- no error, no exception
  2. But after the excel file opened and save as , then file size reduced to 20 and then upload success, No error in mapping.

Would like to know is there an workaround for this ?

Below image shows the code, which using to upload excel

image
donnytian commented 1 year ago

this seems an NPOI issue when reading the file. Sorry I don't have any workaround for now.