Search code examples
c#.netepplus

Detect "#VALUE!" cells in EPPLUS C#


I was wondering if there is anyway to detect cells with invalid references where they appear as #VALUE! in the excel sheet. I don't want to detect empty or null cells, but only specifically when they appear as #VALUE!


Solution

  • if (cell.Value is OfficeOpenXml.ExcelErrorValue) { DoSomething(); }