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

System.OutOfMemoryException in Azure #134

Open alanaby01 opened 7 months ago

alanaby01 commented 7 months ago

When I am trying to parse an Excel sheet with 50,000 records, it works fine locally, but it breaks in Azure with System.OutOfMemory exception. When I delete unwanted columns manually and re-run the parser, it works fine. Is there a way to config the parser to avoid parsing certain columns?

donnytian commented 6 months ago

Hi, you can use the Ignore method or attribute.