EPPlus 5/6/7

Features and technical overview

Ignore errors on cell ranges

EPPlus

EPPlus 5/6/7 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