EPPlus 5

Features and technical overview

Ignore errors on cell ranges

EPPlus

EPPlus 5 has the ability to ignore errors on cells.

            
var p = new ExcelPackage();
var ws = p.Workbook.Worksheets.Add("IgnoreErrors");

ws.Cells["A1"].Value = "1";
ws.Cells["A2"].Value = "2";
var ie = ws.IgnoredErrors.Add(ws.Cells["A2"]);
ie.NumberStoredAsText = true;   // Ignore errors on A2 only
            
        

Check out sample 22 for more details.
.NET Core , .NET Framework