How do you determine if a cell has an error such as #NAME? or #VALUE! when reading a spreadsheet with EPPLUS?

Sep 29, 2014 at 4:11 PM
How do you determine if a cell has an error such as #NAME? or #VALUE! when reading a spreadsheet with EPPLUS? What I currently do is:
                    if (worksheet.Cells[i, j] is double && Double.IsNaN((double)worksheet.Cells[i, j] ))
But this seems incomplete. Is there a more elegant way to determine if a cell has an error such as #NAME? or #VALUE! when reading a spreadsheet with EPPLUS?

Ivan
Editor
Oct 1, 2014 at 5:24 PM
I´m pretty sure there is no way to do that, EPPlus can generate Excel files but it isn't a full Excel engine. This kind of problems usually are bad formulas, references, etc. Maybe with the new Calculation Engine (Beta 4.0), you can discover some of that errors, but not all of them.